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