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 a database be shrunk to 0 bytes, if not, why? : Sql server administration

614

Which tcl commands are available on the sql server?

607

How to create a new login name in ms sql server?

551

can SSRS reports Cache results?

113

what are user defined datatypes and when you should go for them? : Sql server database administration

544

can any body tell me how to know the password of current user in sql server

1581

How do you create a data source?

480

How to find the source of a table in sql server?

530

Differentiate between truncate vs delete in mssql?

530

What are binary string data types in ms sql server?

658

Explain the third normal form(3nf)?

525

Explain atomicity?

579

Define Wed Edition in SQL Azure?

What do you understand by recursive stored procedure?

524

What is store procedure? How do they work?

583