RE: Finding duplicate rows
This is a discussion on RE: Finding duplicate rows within the Informix forums, part of the Database Server Software category; --> Hi, You could try Select min(i2.rowid) from ..... It worked for me on a simple test example. Regards, Bryce ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 11:53 AM
| ||||
| ||||
 RE: Finding duplicate rows 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 >      |
Linear Mode
