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

Do you know what are the properties of the relational tables?

1020

Where views are stored in sql server?

973

What are system databases into sql server (2005/2008) : sql server database administration

999

How to fetch the next row from a cursor with a "fetch" statement?

1062

What happens if the update subquery returns no rows in ms sql server?

1113

Can we use trigger new in before insert?

915

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2207

What are the advantages of partitioning?

1090

How to create an index on a view?

1058

What is master database? : SQL Server Architecture

1010

What is data source in connection string?

896

How to list all schemas in a database?

1048

What is the library index called?

1048

How secure is sql server database?

994

What is user-defined multi-statement table-valued function?

1046