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

Sql server reporting services vs. Crystal reports.

131

What are dml triggers and types of dml triggers?

964

What is user defined stored procedures?

916

How to rename databases in ms sql server?

1178

what are the different types of SSRS reports?

151

What is implicit cursors?

1061

Define self join?

1018

Explain transaction server isolation?

1007

Explain the truncate command? : SQL Server Architecture

1146

What is an index in sql?

988

What are the advantages of using stored procedures?

936

why would you use sql agent? : Sql server database administration

1192

What is a partitioned view?

976

What can be used instead of trigger?

1133

Can we delete data from a view?

913