how we can find the second, third hieghest salary in a table?

Hi Amit,


Try this...


For 2nd highest salary here n=2

select distinct(salary)  from employee A where 2=(select count(distinct(salary)) from employee B where A.salary<=B.salary)


For 3rd highest salary here n=3
select distinct(salary)  from employee A where 3=(select count(distinct(salary)) from employee B where A.salary<=B.salary)


Thanks