Answers for "how to find second highest salary in mysql without using subquery"

how to find 2nd highest salary in mysql

#2nd Most highest salary using Group By, Order By & Limit clause
SELECT sal FROM emp GROUP BY sal ORDER BY sal DESC LIMIT 1, 1;

Posted by: Guest on April-09-2021

how to find 2nd highest salary in mysql

#2nd Most highest salary using dense_rank()
SELECT sal 
FROM (SELECT dense_rank() over(ORDER BY sal DESC) AS R, sal FROM emp) employee 
WHERE R = 2;

Posted by: Guest on April-09-2021

Code answers related to "how to find second highest salary in mysql without using subquery"