Nth higest salary

Create table empSalary(eid int,ename varchar(20),esal money,eManager int null)

insert into empsalary values(1,'rghu',20000,null)

insert into empsalary values(2,'en',15000,1)

insert into empsalary values(3,'ven',10000,2)

insert into empsalary values(4,’murthys’,15000,1)

insert into empsalary values(5,'karim',10000,2)

insert into empsalary values(6,'sir',18000,2)

insert into empsalary values(7,'siri',20000,null)

select *from empsalary order by esal desc

--This example 2nd highest salary

--for nth highest salry replace 1 with n-1

select * from empsalary as a where 1=(select count(distinct (esal)) from empsalary as b where b.esal>a.esal)