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

How extra digits are handled with numeric data type literals?

911

How to delete existing rows in a table?

1071

How do you create type- insensitive operator?

994

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

909

How do you make a trace?

955

What is query processing?

881

How to Update from select query in sql server?

993

What are sub reports?

186

Explain “row_number()” in sql server with an example?

948

How to filter out duplications in the returning rows in ms sql server?

1067

How to scale out a federation by Sql statement?

116

Why use identity in sql server?

1009

What are the five major components of a dbms?

881

Define Business Edition in SQL Azure?

100

What number aggregate functions are accessible there in sql?

1007