Also, if you want to get back the PERSON records instead of the SOC_SEC_NO
try.
WITH CTE
AS (SELECT SOC_SEC_NO
FROM PERSON
GROUP BY SOC_SEC_NO
HAVING COUNT(*) > 1)
SELECT PERSON.*
FROM PERSON
INNER JOIN CTE ON (CTE.SOC_SEC_NO = PERSON.SOC_SEC_NO)
Hope this is useful,
Edward
From: [email protected]
[mailto:[email protected]]
Sent: Thursday, February 4, 2016 3:09 PM
To: [email protected]
Subject: RE: [firebird-support] How do find duplicates in a table?
Thanks Woody much simpler.
From: [email protected]
[mailto:[email protected]]
Sent: Thursday, February 04, 2016 1:42 PM
To: [email protected]
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)
