Posts
1150
Comments
891
Trackbacks
1
Finding Dups

select stor_id, ord_num , count(*) as 'Num of Dups'
from pubs.dbo.sales
group by stor_id, ord_num
having count(*) > 1

 

posted on Tuesday, January 18, 2005 9:20 AM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 8 and 7 and type the answer here: