Re: Finding duplicate rows

Posted in 2006

Ben — Thu, 6 Apr 2006 10:12:38 -0400 — source: Usenet: comp.databases.informix

> JaxenT wrote : > >> I am trying to find duplicate rows, and only want to return one rowid >> from the pair. > Just an idea: > > SELECT FIRST 1 i2.rowid FROM > FROM inv i1, inv i2 > WHERE i1.h_num = 698 > AND i2.h_num = i1.h_num > AND i1.inv_date = i2.inv_date > AND i1.order = i2.order> > worked for me I believe this query will only return one row total - not 'one rowid from the pair'...