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 are the restrictions that views have to follow? : SQL Server Architecture

944

How many triggers you can have on a table?

933

What is the full form of dql?

927

What is the advantage of sql server?

985

If any stored procedure is encrypted, then can we see its definition in activity monitor?

935

Define full outer join?

889

What is set nocount on?

893

What is encryption key?

115

how can you attach more than 20 ldf files in sql server

1946

What is sql server replication? : sql server replication

921

What is difference between view and materialized view?

885

What do you understand by a view?

932

How retrieve field names from the table in SQL through JAVA code?

1829

What is user-defined function?

909

What is sql stored procedure?

1012