Delete from Tbl where Id NOT IN( select Min(Id) from tbl Group By Colmn

how to delete duplicate rows in sql server2005

Question Posted / nittu

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

Please Help Members By Posting Answers For Below Questions

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1079

What are the different editions available in sql server 2000?

992

What is the purpose of object explorer and its features? : sql server management studio

1116

What is implicit mode in sql server?

1027

Mention the different types of replication in sql server.

955

What is the difference between deallocate cursor and close cursor?

1164

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

915

What is the concept of optimization?

989

What are the mathematical functions supported by sql server 2005?

993

What is spid in sql server profiler?

1025

What is a not null constraint?

974

What are the difficulties faced in cube development? : sql server analysis services, ssas

997

how many triggers you can have on a table? : Sql server database administration

903

Explain about integration services of Microsoft SQL server?

981

What is sql server profiler trace data file?

1047