Difference between rowid and rownum in SQL?
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 |
Post New Answer View All Answers
What do you know about system database? : SQL Server Architecture
What are the different types of sql server replication? : sql server replication
Do you know the cursor types?
Why should one not prefix user stored procedures with ‘sp_’?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Why use update_statistics command in sql server?
What is difference between temp table and cte?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
what are different types of raid configurations? : Sql server database administration
Can we install sql server 2016 on windows 7?
What are the steps to follow to configure SQL*Net?
How to read data in a table with "select" statements?
What is indexing a document?
Explain what are commit and rollback in sql?
What is the importance of a recovery model?