Difference between rowid and rownum in SQL?
- 1 Answers
- 1045 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer / yash
the difference between ROWNUM and ROWID is that ROWNUM is temporary while ROWID is permanent
| Is This Answer Correct ? | 1 Yes | 0 No |
How to get @@error and @@rowcount at the same time?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is extended stored procedures?
How to create function without parameter in sql server?
How to use wildcard characters in like operations in ms sql server?
What are the dmvs? : sql server database administration
What is co-related sub query?
How to use transact-sql statements to access the database engine?
Where are sql server user names and passwords stored in sql server?
What is PROJECTION Operation?
Explain activity monitors
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
