View Single Post
  #2 (permalink)  
Old 10-09-2006, 04:50 AM
Dimitar
 
Posts: n/a
Default 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!
Reply With Quote