how to delete duplicate rows in sql server2005
Answer Posted / nittu
Delete from Tbl where Id NOT IN(
select Min(Id)
from tbl
Group By Colmn1,Column2)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an etl file?
How would we use distinct statement? What is its use?
what is a join? : Sql server database administration
What is indexing in sql server with example?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How we can compare two database data?
What is thr feature of change data capture?
What is the report builder?
What is the xml datatype?
What is the latest version of microsoft sql server?
How to find the source of a table in sql server?
How can we delete a table in sql server?
What are the properties of the transactions?
how many type of indexing in database?
Explain features of analysis services?