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

what is blocking? : Sql server database administration

1087

Explain what is cte (common table expression)?

1184

Define views.

1068

Give a example to search fr a string in all stored procedure in sql server.

1063

What is transact-sql ddl trigger?

1148

What is sqlservr.exe - process - sql server (sqlex?press)?

1154

What are key constraints?

1018

What are ddl triggers and types of ddl trigger?

1093

How to list all dsn entries on your local machine using odbc_data_source()?

1089

What are the system database in sql server 2005?

1097

Describe and explain about SQL native client?

1157

How many types of local tables are there in sql server?

978

What is the Control Flow in SSIS

1146

Can group functions be mixed with non-group selection fields in ms sql server?

997

what are constraints? : Sql server database administration

1130