|Subject||RE: [firebird-support] How do find duplicates in a table?|
Thanks Woody much simpler.
Try this instead:
Select Soc_Sec_No, count(*) from Person
group by Soc_Sec_No
having count(*) > 1
This will list the social security numbers and the count if there are
more than one without
all the additional selects.