AW: Finding duplicate rows

Posted in 2006

Model-Bosch, Tilman — Thu, 6 Apr 2006 15:43:34 +0200 — 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