Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 67650 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / sujit kumar suman,new delhi
DELETE DUPLICATE RECORDS FROM TABLE IN SQL SERVER:
DELETE FROM TABLE1
WHERE
ID NOT IN
(SELECT MAX(ID) FROM TABLE1
GROUP BY NAME)
WHERE ID IS IDENTITY FIELD AND NAME IS DUPLICATE FIELD
TRY THIS QUERRY AND ENJOY.......
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain how many normalization forms?
What are the advantages of log shipping?
You want to implement the one-to-one relationship while designing tables. How would you do it?
Explain what are the restrictions while creating batches in sql server?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
what are the reporting service components in SSRS?
What are the dmvs?
What is the security principal at the server level that represents your session?
Which is the latest version of sql server and when it is released?
How to provide values to user defined function parameters?
What is exporting utility?
What are the properties of sub-query?
What is inline table-value user-defined function?
Describe how to use linked server?
What are the different types of collation sensitivity?
