Home » SQL & PL/SQL » SQL & PL/SQL » Duplicate rows (3 topics merged)
Duplicate rows (3 topics merged) [message #290200] Thu, 27 December 2007 23:12 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
How can we delete the duplicate rows
Re: Delete the duplicate rows in table [message #290201 is a reply to message #290200] Thu, 27 December 2007 23:14 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Hi Tondapi,

Have you tried of same query with Google or even with forum search ? You will find Tons of links.

Thumbs Up
Rajuvan.

[Updated on: Thu, 27 December 2007 23:15]

Report message to a moderator

Re: Delete the duplicate rows in table [message #290202 is a reply to message #290200] Thu, 27 December 2007 23:17 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>How can we delete the duplicate rows
How do YOU classify/identify "duplicate rows"?
Why did you allow duplicate rows in the database in the 1st place?

Why do you only ask questions & never answer any put to you?
Re: Delete the duplicate rows in table [message #290203 is a reply to message #290200] Thu, 27 December 2007 23:26 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Try with Google search / search in the forum first .
Post the query again if you couldn't find the solution .

Trust me , you will find a lots of solution.

Thumbs Up
Rajuvan.

[Updated on: Thu, 27 December 2007 23:26]

Report message to a moderator

Re: Delete the duplicate rows in table [message #290210 is a reply to message #290200] Fri, 28 December 2007 00:06 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

you can remove duplicate rows like this query

Assume we want to remove duplications for the following column means

Table :table1

empno
101
102
101
103
104

delete from table1 where rowid not in(select min(rowid) from table1 group by empno);

if you want to remove duplications from more than one column means just add another one column like this in sub query

group by empno,empname...

Thanks

Mano


Re: Delete the duplicate rows in table [message #290214 is a reply to message #290200] Fri, 28 December 2007 00:30 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member


This is just one of several solutions available.

There are some other variants too .. just check it out in the forum.

Thumbs Up
Rajuvan.
Duplicate rows? [message #290464 is a reply to message #290200] Sat, 29 December 2007 01:18 Go to previous messageGo to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi Gurus

I want to see the duplicate rows in table.

How can i see .Any One Kindly help me.
Re: Duplicate rows? [message #290466 is a reply to message #290464] Sat, 29 December 2007 01:24 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

and can you post what you tried ?



regards,
Re: Duplicate rows? [message #290468 is a reply to message #290466] Sat, 29 December 2007 01:28 Go to previous messageGo to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Just i want to see the duplicate rows
Re: Duplicate rows? [message #290470 is a reply to message #290468] Sat, 29 December 2007 01:35 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

did you search this forum.you will find many examples which meet your requirement.
search: "Duplicate rows" 432 Search Results Found.

regards,
Re: Duplicate rows? [message #290477 is a reply to message #290464] Sat, 29 December 2007 01:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You already ask this in another topic yesterday.
Stop multiplying the same posts.
Don't post in expert forum, you are a newbie, post in newbie forum.

Regards
Michel
displaying duplicate rows [message #290834 is a reply to message #290200] Tue, 01 January 2008 06:39 Go to previous messageGo to next message
smile@123
Messages: 1
Registered: January 2008
Junior Member
Hi Guru's

Happy New year 2008

I want to see the duplicate rows in my table.

How can i See. Plz help me. I am using rownum function but i am not getting.
Re: displaying duplicate rows [message #290837 is a reply to message #290834] Tue, 01 January 2008 06:55 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Is it a coincidence you share your ip-number with tondapi?
And ask the same question he has asked several times?
Re: displaying duplicate rows [message #290843 is a reply to message #290834] Tue, 01 January 2008 07:59 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Locked and merged.

Regards
Michel

[Updated on: Tue, 01 January 2008 08:01]

Report message to a moderator

Previous Topic: copy another user tables
Next Topic: Which Method is Better Pl-Sql
Goto Forum:
  


Current Time: Fri Dec 09 03:54:47 CST 2016

Total time taken to generate the page: 0.09550 seconds