Home » RDBMS Server » Server Administration » duplicate records
duplicate records [message #371997] Tue, 02 January 2001 13:04 Go to next message
swapan
Messages: 1
Registered: January 2001
Junior Member
how can i locate duplicate records
thanks,
swapan

Report message to a moderator

Re: duplicate records [message #371998 is a reply to message #371997] Tue, 02 January 2001 14:03 Go to previous message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi
select count(*), col1, col2....
from t1
group by col1, col2......
having count(*) > 1

you will get all the duplicate rows

Report message to a moderator

Previous Topic: Insert date/time value into a DATE field (error ORA-01843: not a valid month)
Next Topic: overflow when concatenating strings
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 20:44:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.