Write a query to delete duplicate records in SQL SERVER
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 |
Post New Answer View All Answers
Explain the rules for designing files and file groups in sql server?
Write a SQL query to delete a table?
Explain timestamp datatype?
Explain some stored procedure creating best practices or guidelines?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What are scalar functions in sql?
What are “phantom rows”?
What is TDS(Tabular Data Stream) Gateway?
What is the dbcc command and why is it used?
How to delete duplicate rows in sql server?
What are the character string functions supported by sql server 2005?
What is the sql profiler?
What is an example of a foreign key?
Where in ms sql server is ’100’ equal to ‘0’?