delete form emp where (select distinct(ename)from emp)

Write a query to delete duplicate records in SQL SERVER

Question Posted / rajkamal

Answer Posted / rajkamal

delete form emp
where (select distinct(ename)from emp)

Is This Answer Correct ?

3 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

143

What is exporting and importing utility?

1071

Why is sql server log file full?

1023

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1040

How to loop through result set objects using mssql_fetch_array()?

1061

Mention what are the core components of ssrs?

323

How do you identify a foreign key?

1017

Define Business Edition in SQL Azure?

100

How to create indexed view?

1029

What is user-defined inline table-valued function?

933

Explain what is analysis service repository?

976

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

1008

What security features are available for stored procedure?

1023

How to provide column names in insert statements in ms sql server?

1141

Would you store your query in a ssrs report or a database server? State the reason why?

152