RE: DUPLICATE ROWS.

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Wed, 30 Jun 2004 18:28:49 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKOEIAEPAA.mwf@rsiz.com>

select test_id, count(test_id) from test group by test_id having count > 1;

then for the individual test_id problems, look at them and figure out which one to delete by row_id.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: Wednesday, June 30, 2004 6:22 PM
To: oracle-l_at_freelists.org
Subject: DUPLICATE ROWS.

Here is
select count(test_id) from test;
shows 102 rows

select count(distinct(test_id) from test; shows 100 rows

How to find those 2 rows ?
I tried to run to find by using max rowid or min rowid but unable to.if some one have quesry can pl send to me
thx

Get fast, reliable Internet access with MSN 9 Dial-up – now 3 months FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Wed Jun 30 2004 - 17:25:17 CDT