SQL 92 dialect question:
Selecting Duplicate Entries in a table?
I have a table with about 300 entires in it and I am trying to create a query that only selects the 33 records in the table that are duplicated.
These are my 3 column headings
TOrder_NO
TPart_NO
Qty
In 33 records TOrder_NO and TPart_NO are the same how can i run a query to just select these 33 records.
Cheers
|