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 votes256 views1 answer
Sql like variable
SQL
15 votes393 views2 answers
Sql order by alphabetical
SQL
57 votes448 views6 answers
Mysql alter table add column
SQL
12 votes259 views1 answer
Docker run mysql image
SQL
3 votes250 views3 answers
Mysql select table names
SQL
18 votes268 views6 answers
Laravel form validation
SQL
13 votes215 views2 answers
Oracle all source
SQL
0 vote276 views1 answer
Sqlalchemy orm duplicate
SQL
1 vote292 views1 answer
Myql find duplicates
SQL
10 votes272 views6 answers
Mysql delete duplicates
SQL