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 is a heap?
What are the 7 disadvantages to a manual system?
How to create a view using data from another view?
What are drillthrough reports?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is a user-defined function in the sql server and what is its advantage?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Define self join in sql server joins?
What is BCNF? How is it better than 2NF & 3NF?
What is the use of toad or sqldbx.?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is tempdb database? : SQL Server Architecture
What happens when converting big values to numeric data types?
What is the dbcc command and why is it used?
what is an extended stored procedure? : Sql server database administration