SQL select problem
Posted on 2009-04-21
I have a table with 3 columns : tableID, passNumber and LineNo
There are some rows that have the same tableId and the same Passnumber but a different LineNo.
I know it because if I do a select distinct tableId, passNumber I receive less rows in total...
I need to know wich one are duplicated because its an error to have both tableId and passnumber with a different LineNo So I have to check wich one I will keep.
any idea how to get only those duplicated?