SQL command for accessing second highest salary in database

Question

I have salary field in database from which I want to access second highest salary. What can be the command for same

Satyapriya Nayak · Answer

Hi Stephen Here is your solution. Select max(salary) from employee where salary NOT IN (Select max(salary) from employee) OR General Syntax for Nth highest salary select distinct(salary) from employee A where n=(select count(distinct(salary)) from employee B where A.salary 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 Thanks If this post helps you mark it as answer