RE: DUPLICATE ROWS.

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Wed, 30 Jun 2004 18:32:27 -0400
Message-ID: <6362087FB073D41195B800D0B78284BE0621CB8B@mail01.corp.abwf.com>

Seema,

Tom Kyte showed different examples....look for Removing Duplicates:

http://otn.oracle.com/oramag/oracle/04-jul/o44asktom.html

Muqthar
-----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

* * * * * * * *

The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing,copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. Thank you.

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

Received on Wed Jun 30 2004 - 17:31:01 CDT