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

7 Answers
12085 Views
TCS, Thomson Reuters, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know what is sql service broker?

994

What are the different types of stored procedures?

1065

can you instantiate a com object by using t-sql? : Sql server database administration

960

What is the maximum number of index per table?

1014

How raid can influence database performance?

968

Equi join and non equi join is possible with sql server?

936

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

898

How to optimize stored procedure optimization?

842

Describe triggers features and limitations?

925

What is difference between aggregate and analytic function?

872

What is the rdl file?

123

How to create an inline table-valued function?

906

How many ways to create table-valued functions?

932

What is logon trigger?

1027

what is the difference between a primary key and a unique key? : Sql server database administration

945