Coldfusion and SQL

erikTsomik
erikTsomik used Ask the Experts™
on
I have a table . I need only see the SSN whichare duplicate
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
select SSN from yourtable group by SSN having count(*) > 1
erikTsomikSystem Architect, CF programmer

Author

Commented:
it returns NULL
Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
Commented:
then you do not have any duplicate SSN, except NULL value itself

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial