Re: Finding duplicate rows
This is a discussion on Re: Finding duplicate rows within the Informix forums, part of the Database Server Software category; --> > JaxenT wrote : > >> I am trying to find duplicate rows, and only want to return one ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 11:54 AM
| ||||
| ||||
 Re: Finding duplicate rows > 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'...      |
Linear Mode
