Re: delete duplecated rows

Hi, I have quite some duplecated rows to delete. I tried somebody's suggestion

delete from TABLE_NAME a

        where a.rowid != (select max(row_id) 
        from TABLE_NAME b
        where b.col_name = a.col_name)

but it takes so long, finally I have to kill it.

Any better suggestions?

Thanks  

-- 
Sent  by dbadba62 from hotmail  part  of  com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new