if 3 duplicate records in a table,i want to delete 2 duplicate
records by keeping 1 duplicate and 1 original as it is,how?
- 5 Answers
- 7916 Views
- I also Faced
- E-Mail Answers
Answer Posted / arun ashok
STEP 1 : Insert distinct value in the one new table.
STEP 2 : Delete the values from existing table.
STEP 3 : Again insert the values from new table to existing
table.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the different types of collation sensitivity?
Tell me something about security and sql azure?
How do I schedule a sql server profiler trace?
How do you set a trace flag in sql server?
What language is sql server written in?
How do we know if any query is retrieving a large amount of data or very little data?
How to create function without parameter in sql server?
Tell me extended events in sql server 2008?
What happens if null values are involved in string operations?
What do you understand by mirroring and mention the advantages of the mirroring?
What is the data type of time?
What is ssl in sql server?
What is use of @@ spid in sql server?
What is merge replication?
What are the different types of columns types constraints in the sql server?
