Difference between rowid and rownum in SQL?
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 |
Does a sql server 2005 select statement require a from?
i want table name basis on column name.
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
Why main is user defined function?
Why functions are used in sql server?
What is an index in sql?
What is the difference between getdate and sysdatetime?
How to use "begin ... End" statement structures in ms sql server?
What is the difference between seek predicate and predicate?
What structure can you implement for the database to speed up table reads?
What is sql sandbox in sql server?
State the difference between local and global temporary tables?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)