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 difference between nvl and nvl2?

1024

How to create a simple user defined function in ms sql server?

1064

Different types of keys in SQL?

1138

Tell me can we use custom code in ssrs?

1048

What are logical database components? : SQL Server Architecture

1090

How to query multiple tables jointly?

1036

Explain difference between cross join and full outer join?

1060

Explain log shipping and mention its advantages.

1083

Define cursor locking

1054

What is nonclustered index with included columns ?

1014

What are functions in the sql server?

1287

What are ddl (data definition language) statements for tables in ms sql server?

1148

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

1074

Explain about link server in sql server?

1103

Explain indexed views?

1025