RE: Finding duplicate rows

Posted in 2006

Bryce Stenberg — Thu, 6 Apr 2006 10:50:30 +1200 — source: Usenet: comp.databases.informix

Hi, You could try Select min(i2.rowid) from ..... It worked for me on a simple test example. Regards, Bryce Stenberg IT Department, Harness Racing New Zealand Inc. > -----Original Message----- > From: informix-list-bounces@iiug.org > [mailto:informix-list-bounces@iiug.org] On Behalf Of JaxenT > Sent: Thursday, 6 April 2006 9:36 a.m. > To: informix-list@iiug.org > Subject: Finding duplicate rows > > I am trying to find duplicate rows, and only want to return one rowid > from the pair. If I do (rowid !=): > > SELECT i2.rowid > FROM inv i1, inv i2 > WHERE i1.h_num = 698 > AND i2.h_num = i1.h_num > AND i1.rowid != i2.rowid > AND i1.inv_date = i2.inv_date > AND i1.order = i2.order> > It returns both the rowids, by if I do (rowid < ): > > SELECT i2.rowid > FROMinv i1, inv i2 > WHERE i1.h_num = 698 > AND i2.h_num = i1.h_num > AND i1.rowid < i2.rowid > AND i1.inv_date = i2.inv_date > AND i1.order = i2.order> > it sits and spins. Any idea why that query doesn't work? I > wager it is a nose on my face problem. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >