2nd highest salary in mysql

#2nd Most highest salary using Limit & Order By
SELECT Salary FROM (SELECT Salary FROM Employee ORDER BY salary DESC LIMIT 2) AS Emp ORDER BY salary LIMIT 1;

Source: java67.com

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;

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;

2nd highest salary in mysql

#Corelated Subquery
SELECT Id, Salary
FROM Employee e
WHERE 2=(SELECT COUNT(DISTINCT Salary) FROM Employee p
WHERE e.Salary<=p.Salary)

Source: java67.com

Similar codes

2 votes133 views1 answer
Ifnull postgres
SQL
0 vote144 views2 answers
Oracle create chain rule
SQL
0 vote210 views1 answer
Linux upload database to mysql
SQL
2 votes180 views2 answers
Sql query to copy data from one column to another
SQL
0 vote161 views1 answer
Mysql where in maintain order
SQL
3 votes140 views1 answer
What is having clause
SQL
0 vote184 views2 answers
CREATE OR REPLACE FUNCTION
SQL
0 vote141 views1 answer
Sql developer export connections
SQL
0 vote177 views1 answer
Oracle job session
SQL
7 votes142 views3 answers
Postgresql dump and restore db
SQL