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

Write a code to select distinct records without using the DISTINCT keyword.

1186

What is meant by indexing?

1085

How can you find out which stored procedures are recompiling?

952

What are the steps to follow to configure SQL*Net?

1079

What are the types of dml?

1031

What is indexed view? How to create it?

1071

What is bit data type?

1081

State the difference between union and union all?

985

In which format does an image save in SQL Server database ?

1057

Where are full-text indexes stored?

1036

Why are sql functions used?

1183

What is the beast way to write CTE in SQL Server ?

1094

What is unique key constraint?

1118

How to drop an existing table?

1053

What is the server name in sql server?

1068