Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76418 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
Which tcl commands are available on the sql server?
What is similarity and difference between truncate and delete in sql?
What are built in functions?
What is the maximum rows in sql server table?
Tell me what do we need queues in sql service broker?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What does nvl stand for?
What is use of except clause?
Write a program using SQL queries to find a unique entry in a table.
What is query and its types?
What is the usage of sign function?
What is mean by dml?
How to create an index on an existing table in ms sql server?
How do I start sql server agent automatically?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
