ROWNUM « Select Query « Oracle PL / SQL






1.Use rownum in select clause
2.Use rownum in update set statement
3.Use rownum in where clause to control the row count
4.Use rownum column with order by
5.Use rownum in where clause to limit the row count
6.Limit the query to display only the top 3 highest paid employees.
7.Use rownum to limit the subquery
8.Use rownum = 1 and select into
9.Retrieving the Top Five Students with ROWNUM








10.Getting the Five Most Expensive Products