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
22277 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

What functions can a view be used to performed?

1060

What are the two modes of authentication in sql server?

1070

Write the syntax for stuff function in an sql server?

1030

How to invoke a trigger on demand?

1094

Is t sql the same as sql server?

980

What is a hint?

997

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1037

What is the difference between clustered index and primary key?

922

Define union, union all, minus, intersect?

983

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

1044

what is raid? : Sql server database administration

1045

When does a workload on SQL Azure get throttled?

131

What are the triggers in sql?

1106

Why is normalisation important?

951

Describe the left outer join & right outer join. : sql server database administration

999