Hi,
You can use the following:

[sql]SELECT *
FROM (SELECT ename
,enumber
,sal
,ROW_NUMBER() OVER(ORDER BY sal DESC) rn
FROM emp)
WHERE rn < 3;[/sql]

Also, you can use the DENSE_RANK() functionality to get this done in a better way:

[sql]SELECT *
FROM (SELECT ename
, sal
, Dense_Rank() over(ORDER BY sal DESC
)rn
FROM emp)
WHERE rn < 3;[/sql]



Thanks,
vinay singh
Sagarpur New Delhi, India
email- vinay_1020@live.in