Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 77881 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 acid mean in sql server?
What is temporary table in sql server? Why we use temp table?
How to enter binary string literals in ms sql server?
do you know how to configure db2 side of the application? : Sql server database administration
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is an indexed view?
How efficient you are in oracle and SQL server?
List the ways in which dynamic sql can be executed?
What are wait types?
What are the different subsets of sql?
Does view occupy space?
When should you use an instead of trigger?
How do I start sql server 2017?
Why use identity in sql server?
List out the different types of locks available in sql server?
