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

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1009

Can I disable or restrict ssrs export formats (rendering formats)?

150

What are the disadvantages of indexes?

1090

What are user-defined functions (udfs) in sql server?

989

How to create a scrollable cursor with the scroll option?

999

Create and insert into temp table in sql server?

1033

is there a column to which a default can't be bound? : Sql server database administration

1015

How to convert character strings into numeric values?

1096

What are the differences between lost updates and uncommitted dependencies?

1078

Explain what is the difference between a local and a global temporary table?

1003

Where to find ntwdblib.dll version 2000.80.194.0?

962

What is difference between rownum and rowid?

903

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1009

What have included columns when we talk about sql server indexing?

1037

Explain about extended stored procedure?

940