Execute the following query for each duplicate value. 1.Delete duplicate

Delete duplicate rows from a table without primary key by
using a single query
Table Employee
empname salary
A 200
B 300
A 200
C 400
D 500
D 500

Output should be

A 200
B 300
C 400
D 500

Question Posted / sumathy

14 Answers
22242 Views
I also Faced
E-Mail Answers

Answer Posted / sumathy

Execute the following query for each duplicate value.

1.Delete duplicate of empname='A'

delete top(select count(*)-1 from employee where
empname='A') from employee where empname='A'

2.Delete duplicate of empname='D'

delete top(select count(*)-1 from employee where
empname='D') from employee where empname='D'

Is This Answer Correct ?

9 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the different types of backups available in sql server? : sql server database administration

922

What is sql injection and why is it a problem? : sql server security

1132

Tell me what are the advantages of using stored procedures?

1012

How to maintain a fill factor in existing indexes?

1006

How do I schedule a sql server profiler trace?

977

How to change the password of a login name in ms sql server?

1013

What is extended stored procedures?

966

Can group functions be mixed with non-group selection fields in ms sql server?

940

Why use cursor in sql server?

1077

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

What is analysis service repository?

1023

Please explain go command in sql server?

1051

How to receive output values from stored procedures?

1141

What are different types of table joins?

1003

Name few of the dcl commands in sql?

1007