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 a schema in ms sql server 2005?

958

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1052

What is index fragmentation in ms sql server?

1069

How to bind a view to the schema of the underlying tables?

987

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1050

Differentiate between a having clause and a where clause.

958

Name and describe few console utilities for ssrs?

284

How to use column default values in insert statements in ms sql server?

1021

how to overcome kernel isssues

1617

What is 2nf in normalization?

977

How many databases instances are there in sql server 2000?

1086

What is the command to change the recovery model?

1036

How to change the data type of an existing column with "alter table" statements in ms sql server?

975

What is key attribute?

921

What are data regions?

135