Breaking News: Grepper is joining You.com. Read the official announcement!

how to get second highest salary in each department in sql

Add Answer

Obedient Ocelot answered on July 9, 2020 Popularity 10/10 Helpfulness 2/10

answer how to get second highest salary in each department in sql

related write sql query to find the second highest salary of employee

related How to find third highest salary in SQL

related sql find second highest salary employee

related query to find second highest salary

related second highest salary SQL

how to get second highest salary in each department in sql

Comment

SELECT E.Employers_name, E.dep_number, E.salary
FROM Employers E
WHERE 1 = (SELECT COUNT(DISTINCT salary) 
        FROM Employers B 
        WHERE B.salary > E.salary AND E.dep_number = B.dep_number)
group by E.dep_number

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: each get highest sql

Link to this answer
Share Copy Link

Contributed on Jan 28 2021

Obedient Ocelot

0 Answers Avg Quality 2/10

Closely Related Answers

write sql query to find the second highest salary of employee

Comment

SELECT MAX(Salary) From Employee
 WHERE Salary < ( SELECT Max(Salary) FROM Employee);

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.java67.com

Tags: find

Link to this answer
Share Copy Link

Contributed on Nov 07 2021

Obedient Owl

0 Answers Avg Quality 2/10

How to find third highest salary in SQL

Comment

-- creating Employee table in Oracle
CREATE TABLE Employee (name varchar(10), salary int);

-- inserting sample data into Employee table
INSERT INTO Employee VALUES ('Rick', 3000);
INSERT INTO Employee VALUES ('John', 4000);
INSERT INTO Employee VALUES ('Shane', 3000);
INSERT INTO Employee VALUES ('Peter', 5000);
INSERT INTO Employee VALUES ('Jackob', 7000);

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

Popularity 10/10 Helpfulness 4/10 Language sql

Source: dbfiddle.uk

Tags: find

Link to this answer
Share Copy Link

Contributed on Jun 19 2022

Rasel Ahmed

0 Answers Avg Quality 2/10

sql find second highest salary employee

Comment

/* 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;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find

Link to this answer
Share Copy Link

Contributed on Jul 09 2020

Wide-eyed Wolf

0 Answers Avg Quality 2/10

query to find second highest salary

Comment

SELECT MAX(SALARY) FROM Employee WHERE SALARY < (SELECT MAX(SALARY) FROM Employee)

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find highest highes

Link to this answer
Share Copy Link

Contributed on Apr 26 2022

Mohanbabu Sakthivelu

0 Answers Avg Quality 2/10

second highest salary SQL

Comment

WITH T AS
(
SELECT *,
   DENSE_RANK() OVER (ORDER BY Salary Desc) AS Rnk
FROM Employees
)
SELECT Name
FROM T
WHERE Rnk=2;

Popularity 9/10 Helpfulness 2/10 Language sql

Source: www.geeksforgeeks.org

Tags: highest

Link to this answer
Share Copy Link

Contributed on May 23 2023

Adorable Armadillo

0 Answers Avg Quality 2/10

how to get second highest salary in each department in sql

Contents

More Related Answers

how to get second highest salary in each department in sql

Closely Related Answers

write sql query to find the second highest salary of employee

How to find third highest salary in SQL

sql find second highest salary employee

query to find second highest salary

second highest salary SQL

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.