Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 75352 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
What are the parts of a function?
What can be used instead of trigger?
Define tempdb database?
What is in place upgrade in sql server?
How can we check the sql server version?
What is normalization 1nf 2nf 3nf?
Why we use trigger in sql server with example?
How to call a function from a stored procedure in SQL Server ?
How to test subquery results with the exists operator?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
Why use “pivot” in sql server?
Does index speed up select statements?
Explain primary key in sql server?
What are data regions?
Can you explain what is indexed view? How to create it?
