Is it possible to delete duplicate rows in a table without
using a temporary table ?
Answer Posted / saravanan
select * into #empnew from (select * from emp union select
* from emp) a
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
Explain about the command-line tool SQLCMD?
What is resultset concur_updatable?
What is role playing dimension with two examples? : sql server analysis services, ssas
What are the extra roles available in msdb? : sql server security
Can you explain what is indexed view? How to create it?
Can an entity have two primary keys?
How to truncate the log in sql server 2012? : sql server database administration
How to delete existing rows in a table?
Which joins are sql server default?
Name the different type of indexes in sql?
List the different types of collation sensitivities in sql server?
How to execute a sql statement using mssql_query()?
what kind of lan types do you know? : Sql server database administration
what are the different types of replication you can set up in sql server? : Sql server database administration