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
- 7806 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 is the difference between a primary key and a unique key? : Sql server database administration
How to configure and test odbc dsn settings?
What is the use of @@spid?
Is the primary key column of a table an index in ms sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Can you tell me about the concept of ER diagrams?
What are the difficulties faced in cube development? : sql server analysis services, ssas
What is the server name in sql server?
What are drillthrough reports?
What are the different subsets of sql?
What are the different types of replication are there in sql server 2000?
How to test odbc dsn connection settings?
What is blocking?
Explain about temporary stored procedure?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
