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

3 votes133 views4 answers
Psql list tables in schema
SQL
0 vote142 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
0 vote139 views1 answer
Sql server select ignore dupplicates
SQL
1 vote131 views1 answer
Best sql course
SQL
0 vote166 views2 answers
Mysql show foreign keys
SQL
0 vote132 views1 answer
Mysql add to value
SQL
0 vote138 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
10 votes122 views1 answer
Oracle dependency
SQL
11 votes144 views3 answers
Change column name sql server management studio
SQL
0 vote146 views1 answer
Oracle c# multiple update sql
SQL