SELECT  *FROM
    (
    SELECT *FROM emp
    ORDER BY Salary desc
    )
WHERE rownum <= 10
ORDER BY Salary ;

SELECT  *FROM
    (
    SELECT *FROM emp
    ORDER BY Salary asc
    )
WHERE rownum <= 10
ORDER BY Salary asc;

SELECT  *FROM
    (
    SELECT *FROM emp
    ORDER BY Salary desc
    )
WHERE rownum <= 10
union all
SELECT  *FROM
    (
    SELECT *FROM emp
    ORDER BY Salary asc
    )
WHERE rownum <= 10