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

Question

Hi we are a problem to finding the third hieghest salary in a table

Satyapriya Nayak · Answer

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 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 Thanks

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