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

What is a covered index?

987

What are policy management terms?

1040

How to access the inserted record of an event?

1107

How to insert data into an existing table?

1027

What is difference statement and preparedstatement?

1035

What happens if null values are involved in string operations?

1028

what happens on checkpoint? : Sql server database administration

1156

What are the types of normalization?

1076

What is dbcc? Give few examples.

1083

Determine how to use the inserted and deleted pseudo tables?

1043

Explain following error properties?

1060

What is indexing in sql server with example?

1039

1 01 101 01010

2100

How to convert numeric values to integers in ms sql server?

1159

What is data set in report?

147