Column A holds names, B holds numeric values, and C holds dates.
I want to select distinct names when the date has any value and when column B has no numeric value on more than one occasion.
I want to group by column B if the values = '', because there will be a number of them with different values but the only important thing for this report is when column B is blank.
Here's what I have tried:
SELECT DISTINCT A, B FROM TABLE WHERE (C>'' AND B='') GROUP BY B HAVING COUNT(*) > 1