Site Sections
Posts
463
Comments
322
Trackbacks
1
<< Config points | Home | Google rank >>
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
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 7 and 5 and type the answer here:
Archives
Post Categories
Stuff
  • My Company