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

Explain the rules for designing files and file groups in sql server?

977

Write a SQL query to delete a table?

1127

Explain timestamp datatype?

957

Explain some stored procedure creating best practices or guidelines?

921

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1052

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

971

What are scalar functions in sql?

1133

What are “phantom rows”?

1650

What is TDS(Tabular Data Stream) Gateway?

121

What is the dbcc command and why is it used?

1041

How to delete duplicate rows in sql server?

1091

What are the character string functions supported by sql server 2005?

998

What is the sql profiler?

933

What is an example of a foreign key?

968

Where in ms sql server is ’100’ equal to ‘0’?

1074