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....