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