the difference between ROWNUM and ROWID is that ROWNUM is temporary while R

Difference between rowid and rownum in SQL?

Question Posted / yash

Answer Posted / yash

the difference between ROWNUM and ROWID is that ROWNUM is temporary while ROWID is permanent

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain syntax for viewing trigger?

884

After removing a table from database, what other related objects have to be dropped explicitly?

997

Introduction of rollup clause using sum and group by clause?

898

explain the storage models of olap? : Sql server database administration

879

How to rebuild all indexes on a single table?

993

What are the commands used in DCL?

964

How to create a new table in a given schema?

1111

What is the maximum size of a dimension? : sql server analysis services, ssas

999

How to find the source of a table in sql server?

920

What is outer join in sql server joins?

1044

Explain about builtinadministrator?

985

Do you know what is blocking?

898

What is a schema in ms sql server 2005?

914

What is use of @@ spid in sql server?

1144

What is the difference between locking and multi-versioning?

938