Xref: alice comp.databases.oracle.server:83134
Path: alice!news-feed.fnsi.net!enews.sgi.com!paloalto-snf1.gtei.net!news.gtei.net!newsfeed.stanford.edu!logbridge.uoregon.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: ramesh_joshi@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Identifying duplicate rows
Date: Wed, 02 Feb 2000 22:03:39 GMT
Organization: Deja.com - Before you buy.
Lines: 9
Message-ID: <87a9jn$49l$1@nnrp1.deja.com>
References: <87a0qm$t0q$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Feb 02 22:03:39 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.0 PROXY01, 1.0 x39.deja.com:80 (Squid/1.1.22) for client 161.254.200.117
X-MyDeja-Info: XMYDJUIDramesh_joshi

select number from tab
where rowid > ( select min(rowid) from tab)

Ramesh Joshi
joshir@hsn.net


Sent via Deja.com http://www.deja.com/
Before you buy.