Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 67704 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / mahesh babu ummaneni
inthis we have some steps
-->first rimove duplicate values from table
select distinct * from ta1
-->copy the data into anothetable
select distnice * into tb2 from tb1
-->remove the first table
drop table tb1
-->copy the tb2 data into tb1
select distinct * into tb2 from tb1
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are cursors stored procedures and triggers?
What is difference between views and tables?
Explain the properties of sub-query in sql server?
What are the components of sql server service broker?
Explain trigger classes i.e. Instead of and after trigger?
How to count duplicated values in a column in ms sql server?
How to attach adventureworkslt physical files to the server?
Do you know what guidelines should be followed to help minimize deadlocks?
Difference between 2NF &3NF ?
What is the chart in report?
how will add additional conditions in sql?
What do you understand by coalesce in sql server?
How do you Implement SSIS Packages in your Project?
What is partitioned view?
What are the indexes in sql server?
