Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8791 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
Explain differences between web edition and business edition?
What is the difference between a primary key and a unique key? Are they the same?
Why we use functions in sql server?
which backup strategy you are following at ur company
Can you tell me some of the common replication dmv's and their use? : sql server replication
what is database replication? : Sql server database administration
How to Insert multiple rows with a single insert statement?
Can you explain what are commit and rollback in sql?
What is a covered index?
What are the results of running this script?
What command do we use to rename a db, a table and a column?
In which format does an image save in SQL Server database ?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to convert a table data in XML format in sql server?
How many databases can we create in a single server?
