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

What are the different SQL Server Versions you have worked on?

1071

What is a view in sql?

1035

What is sql or structured query language?

1208

do you know how to configure db2 side of the application? : Sql server database administration

1110

Why use identity in sql server?

1185

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

What is self contained sub query?

1133

How to convert character strings into numeric values?

1175

Why should you use or avoid select * statements?

1096

What are the kinds of subquery?

1089

What is temporary table in sql server? Why we use temp table?

1004

What kind of problems occurs if we do not implement proper locking strategy?

1485

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1018

How to connect php with different port numbers?

1163

What is in place upgrade in sql server?

1115