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

Are all views updatable ?

1144

What is thr feature of change data capture?

973

Explain a join?

1060

How many databases Microsoft SQL server provides?

1076

How to create database with physical files specified in ms sql server?

990

Write a sql query to display the current date?

1088

How much does sql server 2016 cost?

1052

What is sql server 2000 work load governor?

1054

Can you pass expressions to function parameters?

1096

Differentiate between a having clause and a where clause.

961

Do you know what are acid properties?

1069

How do I find the query plan in sql server?

947

What is the difference between mysql and sql server?

1009

What is the difference between varchar and nvarchar datatypes?

1080

What is master database? : SQL Server Architecture

1013