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...:-)
Type: Posts; User: kiran3228; Keyword(s):
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...:-)