Is it possible to delete duplicate rows in a table without using a temporary t

Is it possible to delete duplicate rows in a table without
using a temporary table ?

Question Posted / guest

12 Answers
25759 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Is it possible to delete duplicate rows in a table without using a temporary table ?..

Answer / saravanan

select * into #empnew from (select * from emp union select
* from emp) a

Is This Answer Correct ?

1 Yes

6 No

Is it possible to delete duplicate rows in a table without using a temporary table ?..

Answer / hakoona

Jaare Kameeney

Is This Answer Correct ?

3 Yes

10 No

Post New Answer

More SQL Server Interview Questions

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

0 Answers CSC, IBM,

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers

whats the maximum size of view state??

0 Answers

Define inner join? Explain with an example?

0 Answers

HOW TO RENAME A COLUMN NAME

3 Answers

What is 3nf normalization?

0 Answers

What are clustered and non-clustered index?