SQL 92 answer.
Re: Selecting Duplicate Entries in a table?
[sql]
select torder_no,tpart_no from orders group by torder_no,tpart_no having count(*)>1;
[/sql]
Supposedly two records are equal if Record1.TOrder_NO = Record2.TOrder_NO AND Record1.TPart_NO = Record2.TPart_NO
How did you found you have 33 duplicated records?
Hope this helps!
|