Write a query to delete duplicate records in SQL SERVER
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 the class forname () does?
How can we migrate from SQL server to SQL Azure?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is difference between equi join and inner join?
What is merge?
What are the 3 types of schema?
What are functions in the sql server?
How can you insert null values in a column while inserting the data?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How does recursive cte works in sql server?
How to delete a database in ms sql server?
What is intellisense?
How do I view a stored procedure in sql server?
Is oracle faster than sql server?
What is partitioned view?