delete from employee where Emp_id not in (select min(Emp

How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?

Question Posted / pawan k. dubey

Answer Posted / pawan k. dubey

delete from employee
where Emp_id not in (select min(Emp_id) from employee
group by Emp_Name)

Is This Answer Correct ?

2 Yes

12 No

Please Help Members By Posting Answers For Below Questions

How do you create an execution plan?

882

What is sql service broker?

929

Can you index views?

846

How do I run sql server 2014?

936

What is attribute relationships, why we need it? : sql server analysis services, ssas

906

What is the difference between varchar and nvarchar?

895

How to use clusters?

881

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1024

What does it mean to normalize a database and why would you do it?

934

What is the difference between functions and scalar functions?

1121

What are the three different part of rdl file explain them?

253

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2436

How to check if a table is being used in sql server?

901

Explain having clause?

906

Why I have to use stored procedures?

977