Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 67653 Views
- Infosys, I also Faced
- E-Mail Answers
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 is outer join in sql server joins?
What are the differences between substr and charindex in sql server.
How to connect ms access to sql servers through odbc?
What is difference between commit and rollback when used in transactions?
What is Replication?
When do you think a developer should use sql server-based cursors?
How do we Backup SQL Azure Data?
can you implement data mining in SSRS?
What are the benefits of filtered indexes?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is BCP? When does it used in sql server 2012?
How to execute multiple stored procedures at one time in sql server?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
How do triggers work?
How can you insert null values in a column while inserting the data?
