SQL query

Posted in 1998

Ian Clark — Tue, 03 Feb 1998 16:16:38 GMT — source: Informix-list mailing list archive (1991-1998)

Hi All, I am trying to determine what records are duplicated in a table. select count ( distinct accnum ) from nlmst returns 1138 rows, however; select count (*) from nlmst returns 1170 rows. How do I find the records that are duplicated? Cheers, Ian. Tedious 'office speak' part 3: "Let's go scuba in the think tank."