Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records from the table?(Table must have
unique id)
- 7 Answers
- 12550 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
List some advantages and disadvantages of stored procedure?
What is history table in sql server?
What is a natural primary key?
what is a traditional network library for sql servers? : Sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What are the disadvantages of using the stored procedures?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Can you get second highest salary from the table?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What are the disadvantages of merge replication?
How to list all user defined functions in the current database?
Working with TLogs
What are sql servers used for?
Why is replication required on the sql server?
Explain Normalization and DE normalization
