with DeleteDups as ( Select * from TableA AS T1 where KeyCol

how to delete duplicate rows in sql server2005

Question Posted / enis ertem

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

Please Help Members By Posting Answers For Below Questions

Is it possible to have clustered index on separate drive from original table location?

955

System requirements for sql server 2005 express edition?

1001

Name the different type of indexes in sql?

950

what is package and it uses and how can u call a package

2010

What is Cross Join and in which scenario do we use Cross Join?

1008

How to throw custom exception in Stored Procedure?

1037

What is cdc in sql server?

989

Explain a checkpoint?

1018

How much does sql server 2016 cost?

1046

What is merge?

1002

Why truncate is ddl command?

1054

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1028

what is unique and xaml nonclustered index

1039

Is the order of columns in the set clause important in ms sql server?

961

Tell me what is normalization? Explain different forms of normalization?

1026