Multiple Records with Condition

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Multiple Records with Condition

Author

Topic

LiquidTobi
Starting Member

4 Posts

Posted - 2006-08-29 : 16:54:38

I know how to query up duplicate records, here is what I am using to do so:


Select PhoneNum, Count(PhoneNum) as NumOccurances
From Tester
Group By PhoneNum
Having (Count(PhoneNum) > 1)

when the duplicates arise, I expect them to have unique CallResultCode values, and I would like to make a priority of which value stays and which one gets dumped, keep in mind that I am a SQL noob.

Registered Linux User #365191

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-08-29 : 17:03:45

Deleting Duplicate Records article

Tara Kizer

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources