Re: duplicate values

Posted in 1999

Sue_Davidson@exe.com.au — Thu, 23 Sep 1999 14:44:20 +1000 — source: Informix-list mailing list archive (1991-1998)

select count(*), colname from tablename group by colname having count(*) > 1 Phillip Tien <phillip.tien@wholefoods.com> on 23/09/99 13:06:07 Please respond to Phillip Tien <phillip.tien@wholefoods.com> To: informix-list@iiug.org cc: (bcc: Sue Davidson/EXE) 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.