Re: SQL query

Posted in 1998

Dave Otto — Tue, 3 Feb 1998 09:29:21 -0800 — source: Informix-list mailing list archive (1991-1998)

select rowid, count(distinct accnum) from nlmst group by count(distinct accnum) having count(distinct accnum) > 1 Ian Clark wrote in message <34d71c11.948893931@news.demon.co.uk>... >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."