duplicate values

Posted in 1999

Phillip Tien — Wed, 22 Sep 1999 21:06:07 -0500 — source: Informix-list mailing list archive (1991-1998)

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.

↪ replying to Phillip Tien

Michael Krzepkowski — Thu, 23 Sep 1999 03:04:21 GMT — source: Informix-list mailing list archive (1991-1998)

Hi! Try: select column,count(*) from table group by column having count(*) > 1; HTH Michael Phillip Tien wrote: > 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.