Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records from the table?(Table must have
unique id)
- 7 Answers
- 12141 Views
- TCS, Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / kk
DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn3)
| Is This Answer Correct ? | 7 Yes | 7 No |
Post New Answer View All Answers
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is a View ? Can we insert, Update and delete a view?
What are alternate keys?
What are the drawbacks of reporting in ssrs?
How can we delete a table in sql server?
How to integrate the ssrs reports in application?
Do you know hot add cpu in sql server 2008?
How do I install only the client tools of sql server 2000?
What is store procedure? When do you use?
Why use view instead of a table?
What is advantage data architect?
How to use linked server?
What are the benefits of normalization?
What is an identity?
