SEO

#1 (**permalink**) 04-20-2008, 10:53 AM

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.

#2 (**permalink**) 04-20-2008, 10:54 AM

this topic has been discussed quite recently:

http://groups.google.co.uk/group/com...d95feae0fd0772

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Finding duplicate rows