Re: SQL query

Posted in 1998

Charles R. Phares — Tue, 03 Feb 1998 08:44:17 -0800 — source: Informix-list mailing list archive (1991-1998)

select count(*), accnum from nlmst group by accnum having count(*) > 1 -C Ian Clark wrote: > > 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."