OraFAQ Forum: SQL & PL/SQL » duplicate row elimination

Home » SQL & PL/SQL » SQL & PL/SQL » duplicate row elimination (Oracle 10.2.0.4.0 on OEL 5)

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

duplicate row elimination [message #597663]

Mon, 07 October 2013 07:26

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

Hi Michel, for eliminating duplicate rows in a table, how to write an sql query?

Report message to a moderator

Re: duplicate row elimination [message #597665 is a reply to message #597663]

Mon, 07 October 2013 07:29

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at OraFAQ's How does one eliminate duplicate rows from a table.

Report message to a moderator

Re: duplicate row elimination [message #597666 is a reply to message #597663]

Mon, 07 October 2013 07:29

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

There are millions of answers if you simply google. Is there any specific issue that you are facing?

A simple demo from asktom http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:15258974323143

[Updated on: Mon, 07 October 2013 07:31]

Report message to a moderator

Re: duplicate row elimination [message #597732 is a reply to message #597666]

Mon, 07 October 2013 23:19

8939513598$
Messages: 103
Registered: July 2013
Location: chennai

Senior Member

Hi Michel & Lalit,Iam apologizing for my way of questioning, as iam a begineer to the field ,i need to learn a lot of things,and, thanks for your suggestion & for your valuable time, patiently providing me answer,...

Report message to a moderator

Re: duplicate row elimination [message #597735 is a reply to message #597732]

Tue, 08 October 2013 00:00

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

But, any skills you have, you can always search before posting, this will:
1/ Improve your skills in searching what you want
2/ Improve your skills in Oracle by finding what you want
3/ Improve your skills in Oracle and other domains by finding other things when searching

Report message to a moderator

Previous Topic:	Want to ZIP clob field in Oracle
Next Topic:	Queue table - error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 21:24:45 CDT 2024