Rownum Examples

Example 1

Select rownum, type, name
  From jobs
Where rownum > 1200 ; Order By name;

Example 2

Select * From
  (Select * From jobs Order By job_id)
Where rownum < 100 ;


Example 3

Select name, sal From
  (Select name, sal
     From jobs
  Order By name asc, sal desc )
Where rownum < 325 ;