Organizational Research By

Surprising Reserch Topic questions - 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

Related Hot Questions

Government Jobs Opening