sql query [message #375037] |
Fri, 20 July 2001 04:54 |
Shukla
Messages: 5 Registered: July 2001
|
Junior Member |
|
|
hi,
i have table having six columns.this table contains around 1,00,000 records.there are some duplicate rows.there is no primary or unique key for this table.to find out all these duplicate rows i m running following query :
select * from tab_1 where rowid not in(select max(rowid) from tab_1 group by col1,col2,...,col6);
this query is taking a lot of time around 12 hrs to run.is there any other method with which i can retrieve these row quickly?please help.
thanks in advance
shukla
|
|
|