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

Who is the owner of a schema in ms sql server?

1071

What is the command to change the recovery model?

1040

How to find the login name linked to a given user name?

1006

Is sql server free?

913

What is difference between temp table and cte?

1011

How to delete exactly duplicate records from a table?

1061

Explain Reporting Life Cycle?

127

What is the difference between clustered and non-clustered indexes in ms sql server?

994

What is clustered index

1000

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1016

How to create view in stored procedure sql server?

1015

What is the most common trace flags used with sql server?

1040

Explain following error properties?

1010

What is the usage of the sign function?

1102

How to optimize stored procedures in sql server?

1181