Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


Question:What is ROWNUM and ROW_NUMBER ?


  1. ROWNUM is a pseudocolumn which is the number assigned to each row retrieved.
  2. - ROW_NUMBER is an analytic function which does something similar, but has all the capabilities of PARTITION BY and ORDER BY clauses..

asked Sep 13, 2013 in ORACLE by anonymous
edited Sep 12, 2013
0 votes
16 views



Related Hot Questions



Government Jobs Opening


...