Re: Query to fetch 100 distinct rows
From: Rohit Kanchan <kanchan_rohit_at_yahoo.com>
Date: 6 Oct 2001 01:57:50 -0700
Message-ID: <9b16d634.0110060057.3640d8ca_at_posting.google.com>
Date: 6 Oct 2001 01:57:50 -0700
Message-ID: <9b16d634.0110060057.3640d8ca_at_posting.google.com>
The following query can be executed to list duplicate rows in a table:
SELECT FROM duplicate_table
WHERE rowid not in
(SELECT MIN(rowid)
FROM duplicate_table
Where column1, column2, column3 are the columns that make up the key that is supposed to uniquely identify the row. Received on Sat Oct 06 2001 - 10:57:50 CEST