Second max salary in sql

Sql select second max

Both options you find max as a subset and then exclude from main select
sql> SELECT MAX( col ) FROM table
 	WHERE col < ( SELECT MAX( col ) FROM table);
sql> SELECT MAX(col) FROM table 
WHERE col NOT IN (SELECT MAX(col) FROM table);

Source: stackoverflow.com

Sql find second highest salary employee

/* sql 2nd highest salary employee */
select sal, ename
from emp
where sal =
    (
        select max(sal) from emp where sal <
            (select max(sal) from emp)
    )
----------------------------------------------- option 2
select *
from 
(
    select ename, sal, dense_rank() over(order by sal desc) rank
    from emp
)
where rank =2;

How to get max salary in each department in sql

SELECT firstname, MAX(salary)
FROM department d LEFT OUTER JOIN employee e
ON (d.department_id = e.department_id)
GROUP BY department_id;

2nd max salary query in sql

select *from employee 
group by salary 
order by  salary desc limit 1,1;

First max salary in sql

SELECT first-name
FROM employees
WHERE salary = (SELECT MAX(salary) FROM employees);

Second max salary in sql

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

Similar codes

0 vote147 views1 answer
How to combine first and last nae into one columb sql
SQL
9 votes132 views3 answers
Sql delete where in
SQL
18 votes126 views3 answers
Mysql add column with default value
SQL
0 vote155 views1 answer
Sql server pivot rows to columns
SQL
0 vote124 views2 answers
Clear window pl sql
SQL
0 vote155 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote141 views1 answer
ACCEPT nome PROMPT on oracle
SQL
1 vote126 views1 answer
Sql restore backup query
SQL
2 votes148 views1 answer
Grant revoke privileges to mysql username
SQL
4 votes166 views1 answer
How to drop a database in sql server when it is in use
SQL