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

What is the openxml statement in sql server?

1007

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

896

What is the difference between lock, block and deadlock? : sql server database administration

989

What is the correct order of the logical query processing phases?

871

How to retrieve error messages using odbc_errormsg()?

988

Why variables called the most powerful component of ssis?

1025

How are the unique and primary key constraints different?

1002

What is sharding?

114

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2016

What is always encrypted?

939

How the authentication mode can be changed?

1074

How many joins in sql server?

897

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1127

What are the advantages of using stored procedures?

887

Tell me about the approaches which you used to counter the DI problems.

1267