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 are distributed partitioned views?

1009

How to download and install the scaled-down database adventureworkslt?

954

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1029

Which are the important points to note when multilanguage data is stored in a table?

912

Why do we use functions?

857

How will you add a dimension to cube? : sql server analysis services, ssas

1013

What is the chart in report?

144

Explain active/passive and active/active cluster configurations?

1017

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1008

What are dml triggers and types of dml triggers?

924

What is join query?

840

How to find index size for each index on table?

964

What is a primary key?

901

Can you explain what is sql server english query?

949

What is coalesce in sql server?

996