Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: duplicate rows in big table
I had an error in my first post, in the "HAVING" clause.
change to:
SELECT COLUMN1, COUNT(ROWID)
FROM TABLE_WITH_DUPES
GROUP BY COLUMN1
HAVING COUNT(ROWID) > 1;
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 30 2000 - 14:56:31 CDT