Hi Every one...

Please let me know how to write this query......

Lets say I have the following data in a table which has 3 columns..

X Y Ind
1 1 Y
2 1 N
3 1 Y
4 1 Y
5 2 Y
6 3 Y


I want to write a query to retrieve all the rows with ind = 'Y' and also the rows which do not have y values duplicated...Inthis case my query should retrieve...
5 2 Y
6 3 Y

X column is primary key.....How do I eliminate duplicates in Y column...

Appreciate your help...



Thanks....