Xref: alice comp.databases.oracle.server:83098
Path: alice!news-feed.fnsi.net!cyclone.i1.net!newsfeed.enteract.com!hermes.visi.com!news-out.visi.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: milesr@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: Identifying duplicate rows
Date: Wed, 02 Feb 2000 19:33:41 GMT
Organization: Deja.com - Before you buy.
Lines: 44
Message-ID: <87a0qm$t0q$1@nnrp1.deja.com>
X-Article-Creation-Date: Wed Feb 02 19:33:41 2000 GMT
X-Http-User-Agent: Mozilla/4.7 [en]C-CCK-MCD (WinNT; U)
X-Http-Proxy: 1.0 x35.deja.com:80 (Squid/1.1.22) for client 164.117.99.184
X-MyDeja-Info: XMYDJUIDmilesr

Hi all,

 I'm trying to develop the PL/SQL code that can list only numbers that
are duplicates, for example:

 NUMBER
  12
  12
  13
  14
  15
  16
  16
  16
  16
  17
  18
  19
  20
  21
  22
  23
  24
  24
  24
  24
  24

 The desired output should look like this:

NUMBER
  12
  16
  24


Any help would be appreciated.


Ronald


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