Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Identifying duplicate rows
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.
Received on Wed Feb 02 2000 - 13:33:41 CST