Answers for "write a query to find 2nd highest salary"

sql 2nd highest salary

select *from employee 
group by salary 
order by  salary desc limit 1,1;

Posted by: Guest on September-06-2021

write sql query to find the second highest salary of employee

SELECT MAX(Salary) From Employee
 WHERE Salary < ( SELECT Max(Salary) FROM Employee);

Posted by: Guest on November-07-2021

Code answers related to "write a query to find 2nd highest salary"