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

How to find third highest salary in SQL

Add Answer

Rasel Ahmed answered on June 28, 2020 Popularity 10/10 Helpfulness 4/10

answer How to find third highest salary in SQL

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

related query to find third highest salary

related sql find second highest salary employee

related sql highest salary by location

related second highest salary SQL

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

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 highest sql

Link to this answer
Share Copy Link

Contributed on Jun 19 2022

Rasel Ahmed

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 4/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

query to find third highest salary

Comment

-*FOR THIRD HIGHEST SALARY*

Select top 1 from (select top 3 salary from emp order by salary desc)
order by asc

Popularity 8/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find highest

Link to this answer
Share Copy Link

Contributed on Apr 26 2022

Mohanbabu Sakthivelu

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

sql highest salary by location

Comment

/*  Highest salary by Department/Location   */
SELECT e.ename, e.sal, e.deptno, d.loc
FROM emp e
JOIN dept d
ON e.deptno = d.deptno
WHERE e.sal in
( 	
  	select max(sal) 
  	from emp 
  	group by deptno
)

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: highest

Link to this answer
Share Copy Link

Contributed on Jun 28 2020

Wide-eyed Wolf

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

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

Link to this answer
Share Copy Link

Contributed on Jan 28 2021

Obedient Ocelot

0 Answers Avg Quality 2/10

How to find third highest salary in SQL

Contents

More Related Answers

How to find third highest salary in SQL

Closely Related Answers

write sql query to find the second highest salary of employee

query to find third highest salary

sql find second highest salary employee

sql highest salary by location

second highest salary SQL

how to get second highest salary in each department in sql

Grepper

Documentation

Social

Legal

Contact

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