Home » RDBMS Server » Server Administration » remove dupicate record
remove dupicate record [message #59432] Wed, 19 November 2003 08:08 Go to next message
Joan
Messages: 36
Registered: February 2002
Member
I have table with one column emp_no that is primary key. there some duplicate in the table and I need to remove it..Thanks

Report message to a moderator

Re: remove dupicate record [message #59433 is a reply to message #59432] Wed, 19 November 2003 08:20 Go to previous messageGo to next message
Jay
Messages: 127
Registered: October 1999
Senior Member
You may be do a SELECT first to find the duplicate records like this :
select emp_no from table_name group by emp_no having count(emp_no) > 1
then you can delete those records as you need

Report message to a moderator

Re: remove dupicate record [message #59434 is a reply to message #59432] Wed, 19 November 2003 08:49 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
the easiest methods are posted [url=http://www.orafaq.net/faqsql.htm#ONLOGON]here<a/>

Report message to a moderator

Previous Topic: Record not getting committed
Next Topic: Encrypted columns - how to
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:25:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.