Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itsonlyme4
Posting Yak Master
109 Posts |
 Posted - 2008-12-22 : 12:00:51
|
| Select count (*) from tower.nbdocdeletedrecordsWhere scandate = '12/13/2008'and slevel = 6Returns 5798 recordsselect distinct towid from tower.NBdocdeletedrecords where slevel=6 and scandate = '12/13/2008' and username = 'SQLKofc'returns 2899 records which is correctHow do I delete the duplicates??? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
duplicate records