Xref: alice comp.databases.oracle.server:83131
Path: alice!news-feed.fnsi.net!enews.sgi.com!newsfeed.mathworks.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: joe_celko@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Identifying duplicate rows
Date: Wed, 02 Feb 2000 21:54:09 GMT
Organization: Deja.com - Before you buy.
Lines: 14
Message-ID: <87a91t$3qs$1@nnrp1.deja.com>
References: <87a0qm$t0q$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Feb 02 21:54:09 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.0 x24.deja.com:80 (Squid/1.1.22) for client 63.72.155.114
X-MyDeja-Info: XMYDJUIDjoe_celko


>>  I'm trying to develop the PL/SQL code that can list only numbers
that are duplicates ... <<

 SELECT nbr
   FROM Foobar
  GROUP BY nbr
 HAVING COUNT(*) > 1;

--CELKO--


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