>Hello All, > >I have a table from which I need to select unique rows. Because the table contains dups. We are trying to select the unique or non-unique rows using 2 columns. Select Distinct does not seem to work on multiple rows. Any suggestions? TIA. > >Regards, > >Paige
Is this what you want?
SELECT col1, col2 FROM table GROUP BY col1, col2 HAVING COUNT(*) > 1