drop table #TEMP select distinct * into #TEMP from TABLE

How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?

Question Posted / arun kumar k s

Answer Posted / arun kumar k s

drop table #TEMP select distinct * into #TEMP from
TABLE_NAME delete from TABLE_NAME insert into TABLE_NAME
select * from #TEMP

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Does a server store data?

863

Can a cursor be updated? If yes, how you can protect which columns are updated?

1029

List out a number of the wants to setup a SQL Server failover cluster?

1006

Is the order of columns in the set clause important in ms sql server?

926

Can we delete data from a view?

880

What is the user of Primary key?

922

Describe in brief system database.

947

What are the advantages of paper records?

907

How will you go about resolving deadlocks?

908

Explain ms sql server reporting services vs crystal reports?

854

How dts is used to extract, transform and consolidate data?

1020

How many types of database relationship in sql server?

993

1 01 101 01010

2004

How to find related tables in sql server?

870

How to insert multiple rows with a subquery?

1059