OraFAQ Forum: Server Administration » deleting duplicate rows

Home » RDBMS Server » Server Administration » deleting duplicate rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

deleting duplicate rows [message #374384]

Sat, 09 June 2001 01:11

Ranjitha
Messages: 1
Registered: June 2001

Junior Member

how to delete all the rows in a table having duplicate values

Report message to a moderator

Re: deleting duplicate rows [message #374393 is a reply to message #374384]

Sat, 09 June 2001 21:44

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

delete from emp t1 where rowid <>
(select max(rowid) from emp t2
where t1.empid = t2.empid
and t1.ename = t2.ename
.....................
....................);

would delete the duplicate rows..

Bala.

Report message to a moderator

Re: deleting duplicate rows [message #374402 is a reply to message #374384]

Mon, 11 June 2001 00:06

baru k das
Messages: 4
Registered: June 2001

Junior Member

good question and very good answer. thanx everybody.

Report message to a moderator

Re: deleting duplicate rows [message #374403 is a reply to message #374384]

Mon, 11 June 2001 00:07

baru k das
Messages: 4
Registered: June 2001

Junior Member

good question and very good answer by Mr. Bala. thanx everybody.

Report message to a moderator

Re: deleting duplicate rows [message #374404 is a reply to message #374384]

Mon, 11 June 2001 00:13

baru k das
Messages: 4
Registered: June 2001

Junior Member

good question and very good answer by Mr. Bala. thanx everybody.

Report message to a moderator

Re: deleting duplicate rows [message #374405 is a reply to message #374384]

Mon, 11 June 2001 00:17

baru k das
Messages: 4
Registered: June 2001

Junior Member

good question and very good answer by Mr. Bala. thanx everybody.

Report message to a moderator

Re: deleting duplicate rows [message #374598 is a reply to message #374384]

Wed, 20 June 2001 15:00

Toyn
Messages: 36
Registered: April 2001

Member

In the above solution, I take emp to signify tablename. However, what are empid and ename?
Is empid a uniquely identified column?
not quite sure about ename??
thanks.

Report message to a moderator

Re: deleting duplicate rows [message #374599 is a reply to message #374384]

Wed, 20 June 2001 15:05

Toyn
Messages: 36
Registered: April 2001

Member

In the above solution, I take emp to signify tablename. However, what are empid and ename?
Is empid a uniquely identified column?
not quite sure about ename??
thanks.

Report message to a moderator

Previous Topic:	Stored Procedure problem
Next Topic:	Date comparison

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 06 05:57:47 CDT 2024