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)
