| Subject | RE: [firebird-support] How do find duplicates in a table? |
|---|---|
| Author | stwizard |
| Post date | 2016-02-04T20:09:21Z |
Thanks Woody much simpler.
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, February 04, 2016 1:42 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How do find duplicates in a table?
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.
HTH
Woody (TMW)