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
What are the different SQL Server Versions you have worked on?
What is a view in sql?
What is sql or structured query language?
do you know how to configure db2 side of the application? : Sql server database administration
Why use identity in sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is self contained sub query?
How to convert character strings into numeric values?
Why should you use or avoid select * statements?
What are the kinds of subquery?
What is temporary table in sql server? Why we use temp table?
What kind of problems occurs if we do not implement proper locking strategy?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to connect php with different port numbers?
What is in place upgrade in sql server?