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

What is the difference between resultset and resultsetmetadata?

1028

What is identity?

1080

What is database architecture? : SQL Server Architecture

1095

What is a transact-sql statement batch in ms sql server?

1063

How to use old values to define new values in update statements in ms sql server?

1330

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1106

How do you create an execution plan?

996

What is reference section?

1051

Tell me something about security and sql azure?

116

how to control the amount of free space in your index pages? : Sql server database administration

1083

What is msdb database? : SQL Server Architecture

1194

What is a sql join?

1079

what is the difference between a primary key and a unique key? : Sql server database administration

1037

What are horizontal and vertical scaling?

172

List all the types of user-defined functions?

1177