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

Tell me what is a linked server?

1000

What stored by the tempdb ? : sql server database administration

1017

How check triggers in sql server?

933

What is the difference between indexing and hashing?

1108

What is sql server profiler trace data file?

1073

What is the difference between varchar and varchar(max) datatypes?

1023

Explain system functions or built-in functions? What are different types of system functions?

932

What is the filtered index?

995

what are the different types of SSRS reports?

149

Write a sql query to sort on different column name according to the parameters passed in the function?

861

How to recover from sql injection? : sql server security

975

How do I connect to sql server database?

973

What protocol does sql server use?

904

What are the advantages of using third-party tools?

938

How to use wildcard characters in like operations in ms sql server?

1090