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 precedence constraint?

990

How to download and install sql server 2005 books online?

1195

What is the use of commit?

1003

Explain various data region available in ssrs with their use?

938

What is a schema in ms sql server 2005?

980

How can you stop stored procedures from recompiling?

903

What is subquery in sql?

1074

What are the 10 characteristics of data quality?

957

Define indexes?

1050

Where the sql logs gets stored?

992

What is a sql join?

1029

Are null values the same as that of zero or a blank space?

1042

What are the database roles? : sql server security

1196

What samples and sample databases are provided by microsoft?

1045

In which tcp/ip port does sql server run? Can it be changed?

996