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 "scheduled jobs" or "scheduled tasks"?

1027

What is it’s similarity with sql server?

160

Are resultset updatable?

1006

How to recreate an existing index in ms sql server?

1116

What are types of storage modes? : sql server analysis services, ssas

1082

What is Federation Root Database?

104

What are the types of subquery?

1096

What is the process of indexing?

1051

What are scalar functions in sql?

1208

Define cross join in sql server joins?

1078

Explain how to maintain a fill factor in existing indexes?

1035

Explain filtered indexes benefits?

1042

Can you explain what is the use of custom fields in report?

1099

How to count rows with the count(*) function in ms sql server?

1059

How do you create a data source?

960