Ganeswar Barik: top-N query.

Showing posts with label top-N query.. Show all posts

Monday, 5 November 2012

SELECT *

  FROM (SELECT *

            FROM emp

        ORDER BY sal DESC)

 WHERE ROWNUM <= 5;