Re: how to delete the duplicated rows from a table

From: Karen Jiang <karennj_at_dandee.net>
Date: 2000/07/11
Message-ID: <MVLa5.15932$Uq6.291324@typhoon2.ba-dsg.net>#1/1

I happened to do this a couple of days ago.

select rowid from table
where column_name in (select column_name from table # column_name contains duplicate records

                                    group by column_name
                                    having count(column_name) > 1);

Then you can look at records and delete them by specifying rowid.

Karen

<dbajjer_at_my-deja.com> wrote in message news:8kfu2e$3uh$1_at_nnrp1.deja.com...
| Hi, I am tring to select the duplicated rows from a table and delete
| them. Please advice how to do so. Thanks JJer
|
|
| Sent via Deja.com http://www.deja.com/
| Before you buy.
Received on Tue Jul 11 2000 - 00:00:00 CDT