select * into #empnew from (select * from emp union select * from emp) a

Is it possible to delete duplicate rows in a table without
using a temporary table ?

Question Posted / saravanan

Answer Posted / saravanan

select * into #empnew from (select * from emp union select
* from emp) a

Is This Answer Correct ?

1 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

967

Explain about the command-line tool SQLCMD?

1078

What is resultset concur_updatable?

1013

What is role playing dimension with two examples? : sql server analysis services, ssas

994

What are the extra roles available in msdb? : sql server security

1122

Can you explain what is indexed view? How to create it?

889

Can an entity have two primary keys?

973

How to truncate the log in sql server 2012? : sql server database administration

1272

How to delete existing rows in a table?

1146

Which joins are sql server default?

994

Name the different type of indexes in sql?

950

List the different types of collation sensitivities in sql server?

1036

How to execute a sql statement using mssql_query()?

1038

what kind of lan types do you know? : Sql server database administration

972

what are the different types of replication you can set up in sql server? : Sql server database administration

1016