How to select data for a unique column ?
Posted on 2006-11-06
I have a table with the following data.
For each unique name, I want to get any one row from the table. I mean to say, since there are 3 unique names (Pankaj, Gaurav, Sangeetha), I want any rows for them. The sample output would be
Pankaj Suneel (Or Pankaj Ahmed will also do)
Gaurav Suneel (Or Gaurav Ahmed will also do)
Sangeetha Ahmed (Because there is a single row).
I am confused. Please help me.