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 many instances per computer are there in sql server 2000?

1116

Explain the properties of a relational table?

1073

How does using a separate hard drive for several database objects improves performance right away?

982

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

934

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1044

Difference between report and query parameter. Why do we need different type of parameter?

1004

How you can change a cross join into an inner join?

1020

Explain candidate key, alternate key, and composite key?

1056

How to create a scrollable cursor with the scroll option?

1045

How do I open port 1433?

982

What's the information that can be stored inside a bit column?

1067

write an SQL query to list the employees who joined in the month of January?

1733

How do you size a resultset?

961

What is xml datatype?

1127

What is buffer cash and log cache in sql server?

1179