Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 77491 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 nonclustered index with included columns ?
What does the on delete cascade option do?
Determine when to use stored procedure to complete sql server tasks?
Can you explain powershell included in sql server 2008?
How to create median function?
what are the disadvantages of cursors? : Sql server database administration
How to choose all records from the table?
What is the fastest way to permanently delete a 1 million row table named customers?
How many types of cursor type are there?
Explain how many normalization forms?
What are the new features of sql server 2008 r2 reporting service?
How to read data in a table with "select" statements?
How do I view a procedure in sql server?
What are points to remember while using the fillfactor argument?
How we can compare two database data?
