Comments by princedesai (Top 3 by date)

I have written the same query above in my question... this is not working bcz there are lot many data

I need only that values where for that specific id there is no Y in any column.

for eg. 1 is having one Y in 3rd row.. so it should be neglected.

according to the above table only 3 and 4 should be returned..