duplicate keys

Posted in 1994

sheltra@emh-1.submepp.navy.mil — 24 Oct 1994 14:03:08 -0400 — source: Informix-list mailing list archive (1991-1998)

Thanks alot for the help for finding duplicate keys. I used the following from Dave Berg. SELECT keycol1, keycol2, ..., keycoln, COUNT(*) from table GROUP BY 1, 2, ..., n HAVING COUNT(*) > 1 Thanks again!!!!