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

How do you delete a data source?

1012

How to find out what is the default collation in a database?

1123

Can we insert data into a view?

1143

How can windows applications connect to sql servers via odbc?

1128

Which language is supported by sql server?

1017

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2011

Would you store your query in a ssrs report or a database server? State the reason why?

152

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1807

How to delete an existing database user?

1020

What is triggers and stored procedures?

943

What are the types of indexes?

1084

How you can change a cross join into an inner join?

975

What is collation sensitivity?

1070

What are the system database in sql server 2008?

1037

Explain the commands in sql server?

1043