Max 3 salary in sql

N highest salary in sql

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP N salary
FROM #Employee
ORDER BY salary DESC
) AS temp
ORDER BY salary

Source: javarevisited.blogspot.com

Nth highest salary in sql

Here is the solution for nth highest
salary from employees table 

SELECT FIRST_NAME , SALARY FROM 
(SELECT FIRST_NAME, SALARY, DENSE_RANK() OVER
(ORDER BY SALARY DESC) AS SALARY_RANK
FROM EMPLOYEES)
WHERE SALARY_RANK = n;

Second max salary in sql

SELECT MAX(SALARY) 'SECOND_MAX' FROM EMPLOYEES
WHERE SALARY <> (SELECT MAX(SALARY) FROM EMPLOYEES);

Max 3 salary in sql

SELECT salary, first_name, last_name FROM employees
ORDER BY salary DESC LIMIT 3;

Min and max salary and name in sql

SELECT FIRST_NAME , SALARY
FROM EMPLOYEES
WHERE SALARY IN (SELECT MAX(SALARY)AS RESULT FROM EMPLOYEES
UNION
SELECT MIN(SALARY)AS RESULT FROM EMPLOYEES);

Similar codes

0 vote179 views1 answer
Create domain sql
SQL
1 vote176 views4 answers
Fatal database postgres does not exist
SQL
0 vote199 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
-1 vote163 views1 answer
Add column alter table default value
SQL
-1 vote230 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote200 views1 answer
Sql basic commands
SQL
0 vote190 views1 answer
How to set up an anonymous function to variable in swift
SQL
56 votes573 views5 answers
Psql create user
SQL
0 vote176 views1 answer
Join in update query in mysql
SQL
0 vote175 views1 answer
Insert overwrite table in mysql in nifi
SQL