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

What is NOT NULL Constraint in sql server 2012?

934

How do use Having,Group by,Group function in SQL?

1691

Is it possible in sql table to have more than one foreign key?

977

What is the purpose of the tempdb database?

957

What does Master database contains?

1082

What happens if strings are casted into wrong code pages in ms sql server?

1062

What do you mean by data integrity?

995

How to delete a login name in ms sql server?

1003

Explain having clause?

908

Explain triggers?

941

Explain the first normal form(1nf)?

966

Explain identity in sql server?

951

Define union, union all, minus, intersect?

932

What is xdr?

929

How to copy data from one table to another table?

932