RE: DUPLICATE ROWS.

try this

select * from test where test_id in ( select test_id from test group by
test_id  having  count(*) > 2 ) 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
Sent: Thursday, July 01, 2004 6:22 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

==============================================================================
This message is for the sole use of the intended recipient. If you received
this message in error please delete it and notify us. If this message was
misdirected, CSFB does not waive any confidentiality or privilege. CSFB
retains and monitors electronic communications sent through its network.
Instructions transmitted over this system are not binding on CSFB until they
are confirmed by us. Message transmission is not guaranteed to be secure.
==============================================================================

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: