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.