Dedupe function , qrite back to sql editor

Toad Data Point
1

Hi ,

is there anyway we can send the calculation to remove duplicates back to sql editor . If not if there any easy of doing it in sql editor itself . We need to perform calculation on top of the dedupe data and will need the sqlquery to make changes .

2

Geting the list of duplicates can be done using SQL but it depends on database you use.

Which one do you use?

Aleksey

3

I use oracle .

Thanks !

Taruna

From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]

Sent: Monday, November 02, 2015 4:20 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Dedupe function , qrite back to sql editor

RE: Dedupe function , qrite back to sql editor

Reply by Aleksey Bazhenov

Geting the list of duplicates can be done using SQL but it depends on database you use.

Which one do you use?

Aleksey

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

This e-mail message, including any attachments, is for the sole use of the person to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Gartner makes no warranty that this e-mail is error or virus free.

4

You can use the following query

select column_name, count(column_name)

from table

group by column_name

having count (column_name) > 1;

Of course, you have to set your own table and column_name

Aleksey

5

That will give you the duplicates. If you want to remove them you need to have something different in each row in order to tell which one to delete (I assume you don’t want to get rid of both rows). If there is nothing to identify the one row to delete (both rows are exactly the same) then store the 1 row to put back in a temp table and delete all duplicate rows.