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

What is the downside of using udf?

1109

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1137

How to disable triggers using "disable trigger"?

1056

Explain few examples of stored procedure over triggers?

1044

When would you use it?

995

What happens to a statement batch if there is a compilation error?

969

What is side by side migration in sql server?

1107

what is datawarehouse?

1115

Why should you use or avoid select * statements?

1030

What are the basic functions for master, msdb, model, tempdb and resource databases?

988

How many instances per computer are there in sql server 2000?

1078

Can we use where clause in union?

1069

What is extent? Types of extents?

1195

What is an etl file?

957

How to write an inner join with the where clause in ms sql server?

1091