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

Explain indexes disadvantages?

1089

What do you mean by table and field in sql?

1015

Explain identity in sql server?

1014

Why do we backup Active Directory ?

1047

How you can get a list of all the table constraints in a database? : Sql server administration

1029

What is function of CUBE ?

1049

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1037

List the different normalization forms?

985

Which is the latest version of sql server and when it is released?

1114

Can we use custom code in ssrs?

1119

What do you understand by the analysis services in sql server?

942

How to define and use table alias names in ms sql server?

1136

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2755

What is updatable resultset?

1010

What are sql azure firewall rules?

106