View Single Post
  #1 (permalink)  
Old 10-09-2006, 01:36 AM
Simon
 
Posts: n/a
Default 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
Edit/Delete Message Reply With Quote

ANSWER(S):