Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76614 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 is an execution plan? How would you view the execution plan?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Is ssrs support other database except ms sql server?
What are the steps you will take to improve the performance of a poor performing query?
How to check if stored procedure is running in sql server?
Does partitioning help performance?
Why would you use sql agent?
Explain what is log shipping?
What is indexed view? How to create it?
Write query to return all rows sql?
Can we insert data if clustered index is disabled?
What is a raid and what are different types of raid configurations?
How do I find the transaction log size in sql server?
What are the transaction properties?
What is Lock table in SQL?
