Re: duplicate values

Posted in 1999

Sujit.Pal@bankofamerica.com — Thu, 23 Sep 1999 09:30:27 -0700 — source: Informix-list mailing list archive (1991-1998)

Phillip Try this SQL: select yourdupcolumn, count(*) from yourtable group by yourdupcolumn where count(*) > 1; This will give you all duplicate column values and the number of times they occur. HTH Sujit Phillip Tien <phillip.tien@wholefoods.com> on 09/22/99 07:06:07 PM Please respond to Phillip Tien <phillip.tien@wholefoods.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: duplicate values Anybody got a handy sql statement to find duplicate values within a column?? -- Phillip Tien If you ever reach total enlightenment while drinking beer, I bet you could shoot beer out of you nose.