Subject RE: [firebird-support] How do find duplicates in a table?
Author Edward Mendez

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: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: Thursday, February 4, 2016 3:09 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] How do find duplicates in a table?

 

 

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)