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
- 8948 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
How do you manipulate data?
What is the use of nvl work?
What is for xml in sql server?
Explain what is cte (common table expression)?
What is user-defined inline table-valued function?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is set nocount on and what is set nocount off?
What is a non equi join?
Why is sql server log file full?
List out some of the requirements to set up a sql server failover cluster?
How do clustered indexes store data?
Explain what are the database objects? : SQL Server Architecture
How you can get a list of all the table constraints in a database?
What are out-of-range errors with date and time literals?
What is ddl command?
