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

Answer Posted / preetpal kapoor

How can we delete duplicate records in a table without
using rowid() function and temporary table?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between clustered and non-clustered index?

529


How to transfer a table from one schema to another?

553


How many types of local tables are there in sql server?

500


What is the use of nvl work?

556


How to set database to be single_user in ms sql server?

553






what is a join? : Sql server database administration

534


What is a partitioned view?

557


What is the dbcc command and why is it used?

560


Does server sql treat char as a variable-length or fixed-length column?

571


Explain logical operators in sql server?

562


Tell me what is difference between clustered and non clustered index?

550


Explain the stored procedure?

625


Can a unique index be created on a column, which contains null?

515


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

1715


What is sqlservr.exe - process - sql server (sqlex?press)?

590