Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> DUPLICATE ROWS.

DUPLICATE ROWS.

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Wed, 30 Jun 2004 18:21:50 -0400
Message-ID: <BAY19-F8ioOLFWXTqDI00053239@hotmail.com>


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
Received on Wed Jun 30 2004 - 17:18:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US