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

How ssrs maintain security?

1016

SQL Server Architecture ?

2396

What are the main differences between #temp tables and @table variables and which one is preferred?

1013

How can you hide the sql server instances?

975

What are joins in sql and what are the different types of joins?

962

What types of Joins are possible with Sql Server?

1058

what are candidate key, alternate key and composite key? : Sql server database administration

852

Is sql server difficult to learn?

863

What are the joins in sql server? : sql server database administration

962

What is a transact-sql statement?

980

What are the source of constraints?

858

Explain microsoft sql server functions?

1033

What is the difference between the 2 operating modes of database mirroring?

1055

Do you know sql server 2008 introduces automatic auditing?

906

Is there any difference between the primary key and unique key?

949