ROWNUM « Table « Oracle PL / SQL






1.Including the ROWNUM pseudo-column in the WHERE clause
2.Only list the first four rows using ROWNUM
3.The values for ROWNUM column are generated before the order by was applied
4.User rownum to get only first 200 records
5.Select the Top 5