delete from emp where id Not in(select max(id) id from emp group by name

Delete duplicate records from the table?(Table must have
unique id)

Question Posted / dinesh kumar

Answer Posted / dinesh kumar

delete from emp where id Not in(select max(id) id from emp
group by name having count(id)>1)

Is This Answer Correct ?

22 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What is bcp? When does it used?

1044

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

1024

What are a database and a data warehouse?

1073

How does using a separate hard drive for several database objects improves performance right away?

990

Define right outer join?

1016

why would you call update statistics? : Sql server database administration

1160

What is ms sql server reporting services?

1125

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1096

Can a table be created inside a trigger?

1014

can a database be shrunk with users active? : Sql server administration

1063

What is the purpose of self join?

1036

How to create an identity column?

1301

What are the types of lock supported by ?

1093

What is indexed view?

1026

How to choose all records from the table?

1104