SELECT distinct column_names INTO temp_table FROM main

Write a query to delete duplicate records in SQL SERVER

Question Posted / abc

Answer Posted / abc

SELECT distinct column_names INTO temp_table FROM main_table
drop table main_table
sp_rename temp_table,main_table

Is This Answer Correct ?

19 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Define left outer join?

967

what is memory-optimized nonclustered indexes

1016

What are the differences between substr and charindex in sql server.

1113

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

What is bcp? When does it use?

943

What is the use of nvl work?

1004

What are the source of constraints?

928

Explain few examples of RDBMS?

1039

can a database be shrunk with users active? : Sql server administration

1007

Explain optimistic and pessimistic concurrency?

993

Is the order of columns in the set clause important in ms sql server?

968

How do I install sql server?

887

What is the difference between clustered and a non-clustered index?

1028

What is the use of group by clause?

942

How to find Duplicate Records In table?

1015