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

Do you know nested transaction?

953

Explain the dirty pages?

996

What is precedence constraint?

975

How to download and install microsoft sql server management studio express?

1030

Give the query of getting last two records from the table in SQL SERVER?

946

What is the use of custom fields in report?

993

What is rolap and its advantage? : sql server analysis services, ssas

1275

Do you know what is difference between stored procedure and user defined function?

1089

Distinguish between commit and rollback?

949

What is the difference between Stored Procedures and triggers?

1074

How global temporary tables are represented and its scope?

966

What is the full meaning of dml?

945

What are types of subqueries?

1060

Is it important for a database administrator to understand the operating system and file access?

972

How to scale out a federation by Sql statement?

116