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

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

Question Posted / ruban

Answer Posted / ruban

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Does index slows down insert statements?

594

Comment,Datatypes are unlimited

1640

What is pivot and unpivot?

648

Explain the cursor lock types?

561

Explain left outer join and right outer join?

575

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

518

How to divide query output into multiple groups with the group by clause in ms sql server?

580

When you use @@error and try-catch?

592

What is PROJECTION Operation?

619

What is a with(nolock)?

589

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

Find first and last day of current month in sql server

603

What is the difference between rank and dense_rank?

515

Mention a few common trace flags used with sql server?

553

What is difference between after and before?

519