Remove duplicate values in table

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

SQL-Server

Hi to all,
how can I remove duplicate values from table?

Posted 30-Jul-12 0:26am

panduu

Updated 30-Jul-12 0:31am

CPallini

v3

Add a Solution

Comments

Kenneth Haugland 30-Jul-12 6:27am

AS you have a uniqe ID column in the SQL database no values are the same.

OriginalGriff 30-Jul-12 6:39am

That's true :laugh: - but it can be a problem if a customer is entered by a number of people who don't realise they already exist.

Karthik Harve 30-Jul-12 6:39am

tell us what exactly you wanted to do?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Kumar Jayaraman · Answer 1 · 2012-07-30T00:50:00

Solution 2

try this.

SQL

select * from temp;

with a as
(
    select row_number() over(partition by id,updateddate order by id) as rn
    from temp
)
delete from a where rn > 1

select * from temp

The output:
3 2012-05-24 10:22:08.523
3 2012-05-24 10:22:08.523

3 2012-05-24 10:22:08.523

Posted 30-Jul-12 0:50am

Santhosh Kumar Jayaraman

Comments

Aarti Meswania 1-Nov-12 0:48am

5+

OriginalGriff · Answer 2 · 2012-07-30T00:38:00

Solution 1

There is a method suggested here: Remove Duplicate Rows from a Table in SQL Server[^] - but read the messages as they suggest some others.

Posted 30-Jul-12 0:38am

OriginalGriff

Comments

panduu 30-Jul-12 11:42am

Thanks for sending and it should be understandble