while @@rowcount != 0 begin delete top (1) test where columnname in (

how to delete duplicate rows from table in sql server

Question Posted / debasish

Answer Posted / debasish

while @@rowcount != 0
begin
delete top (1) test where columnname in
(
select columnname
FROM tablename
GROUP BY columnname having count(*)>1
)
end

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Mention the uses of stored procedures.

962

What are user-defined functions (udfs) in sql server?

979

Define full outer join in sql server joins?

968

What is a unique key constraint?

1022

How to use old values to define new values in update statements in ms sql server?

1251

How to make remote connection in database?

1000

Can a table be moved to different filegroup?

967

How can you check the level of fragmentation on a table?

1036

How to get the definition of a stored procedure back?

973

Explain logical operators in sql server?

1097

What structure can you implement for the database to speed up table reads?

1184

What is sub query and its properties?

970

What is role playing dimension with two examples? : sql server analysis services, ssas

994

How to list all schemas in a database?

1048

What are different type of Collation Sensitivity?

991