Select Top N sal from employee where sal in (select distinct sal from employee order by sal desc)

In the above query N represents the nth highest salary.. I think this help ur problem easily...:-)