select distinct * into #temp from sampletbl delete sampletbl insert into

How to delete the duplicate rows from a table in SQL Server ??

Question Posted / sudha511

Answer Posted / sudha511

select distinct * into #temp from sampletbl
delete sampletbl
insert into sampletbl
select * from #temp
drop table #temp

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why truncate is ddl command?

1054

What is spid in sql server profiler?

1092

What is tcl in sql server?

1112

What encryption security is available in sql azure?

101

How can we improve performance by using SQL Server profiler?

1047

How to use linked server?

1180

Differentiate between delete and truncate.

1054

What is difference between table aliases and column aliases? Do they affect performance?

958

What program is used to store the data source file?

955

mention different types of relationships in the dbms?

1009

What are rest-style architecture's?

170

How data can be copied from one table to another table?

943

How to use column default values in insert statements in ms sql server?

1022

Is sql server is free?

970

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

965