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

Answer Posted / ruban

Use ROWID function. It's available only sql server 2005 and
greater

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to backup SQL Server Reporting Services ?

101


what are user defined datatypes and when you should go for them? : Sql server database administration

516


What is the difference between web edition and business edition?

87


What is difference between count (*) and count column?

501


How you can move data or databases between servers and databases in sql server?

540






Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

491


If user is owning any SQL Objects, can we drop that user

1579


What is temporal data type?

499


How many types of dimensions are there and what are they? : sql server analysis services, ssas

537


Is it true, that there is no difference between a rule and a check constraint?

504


Differentiate between mongodb vs. Sql server?

556


What is sql server used for?

522


What are unicode character string data types in ms sql server?

572


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

560


Differentiate sql server reporting services vs. Crystal reports?

148