how to delete duplicate rows in sql server2005
Answer Posted / enis ertem
with DeleteDups as
(
Select * from TableA AS T1
where KeyCol <
(Select Max(Keycol) from TableA as T2
where t1.Id = T2.ID)
)
Delete from Delete Dups;
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is collation?
Can sql servers linked to other servers like oracle?
What is the openxml statement in sql server?
What triggers long term care?
How to manipulate data from one table to another table ?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What is the bookmark lookup and rid lookup?
What is the difference between lock, block and deadlock? : sql server database administration
What are the reporting services components?
What is a filestream?
Give me a SQL Query to find out the second largest company?
What are approximate numeric data types in ms sql server?
Explain can you implement data mining in ssrs?
Can you explain various data region available in ssrs with their use?