RE: [firebird-support] How do find duplicates in a table?

 

This may works.

SELECT PERSON.PERSON_ID, COUNT(PERSON.SOC_SEC_NO) FROM PERSON HAVING COUNT(PERSON.SOC_SEC_NO) > 1;

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: quinta-feira, 4 de fevereiro de 2016 17:10
To: firebird-support@yahoogroups.com
Subject: [firebird-support] How do find duplicates in a table?

 

 

Greetings All,

 

How do I form a SQL Select statement that will return which records in my PERSON table have duplicate SOC_SEC_NO.

 

In other words I need a list of persons where the social security number appears in the database more than once.  Some SOC_SEC_NO may be null which I do not care about.

 

PERSON:

PERSON_ID

SOC_SEC_NO

 

Any help appreciated,

Mike

__._,_.___

---

Posted by: Peterson Seridonio <loukinho15@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (6)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___