SQL interview Question | Second Highest Salary – Method 1

Question

Write a SQL query to get second highest query using sub query

in progress 0
TheDataMonk 55 years 33 Answers 3603 views Grand Master 0

Answers ( 33 )

  1. Sorry it a private answer.

    10
    Reply

    SELECT Name, MAX(salary) AS salary FROM Table_name WHERE salary < (SELECT MAX(salary) FROM Table_name);

  3. Avneet Singh
    4
    Reply

    SELECT MAX(salary)
    FROM(SELECT salary
    FROM table
    WHERE salary < Max(Salary)) as t;

  4. Pranavb13
    3
    Reply

    SELECT Name, MAX(salary)
    AS salary
    FROM Table
    WHERE salary < (SELECT MAX(salary)
    FROM
    Table);

  5. sukritbhattacharya
    3
    Reply

    SELECT MAX(Salary) FROM Table WHERE Salary < ( SELECT Max(Salary) FROM Table);

    2
    Reply

    SELECT MAX(Salary) FROM Table WHERE Salary < ( SELECT Max(Salary) FROM Table);

  7. swaplaw007
    3
    Reply

    Select max(salary) from table where
    Salary < ( select max(salary) from table)

    1
    Reply

    Select
    From

    where <
    (select from
    )
    Order by DESC
    Limit 1
    1
    Reply

    SELECT MAX(salary) AS salary FROM Table_name WHERE salary != (SELECT MAX(salary) FROM Table_name);

  10. michnoah
    0
    Reply

    SELECT MAX(salary)
    FROM tablename
    WHERE
    Salary < ( SELECT max(salary) tablename)

  11. vinod.k
    0
    Reply

    select * from (select *,dense_rank() over (order by salary desc) as salary_rank from table ) where salary_rank=2;

  12. Sai
    1
    Reply

    select min(salary) from
    (select distinct top 3 salary
    from employees , order by salary desc) as Result
    Order by salary;

  13. Himanshu Sharma
    1
    Reply

    SELECT salary
    FROM
    (SELECT
    salary
    FROM table
    ORDER BY salary ASC
    LIMIT 2
    ) AS a
    ORDER BY salary DESC
    LIMIT 1

  14. sawansaxena
    0
    Reply

    SELECT MAX(salary)
    FROM table
    WHERE salary < ( select MAX(salary) from table)

  15. shivani_1908
    0
    Reply

    select max(salary) from table where salary< (select max(salary) from table);

  16. Smk
    0
    Reply

    SELECT Name, MAX(salary)
    AS salary
    FROM Table
    WHERE salary < (SELECT MAX(salary)
    FROM
    Table);

  17. Shivam Singh
    0
    Reply

    select max(salary) from table
    where salary < (select max(salary) from table);

  18. NaveenaParasa
    0
    Reply

    Consider the table name to be Employee

    SELECT MAX(salary) as Second_Highest_Salary
    FROM Employee
    WHERE Salary < ( SELECT MAX(salary) FROM Employee);

  19. ninja89
    0
    Reply

    select MAX(salary),
    from table_name ,
    where salary < (
    select MAX(salary),
    from table_name ,
    ) ;

    0
    Reply

    SELECT MAX(salary)
    FROM table
    WHERE salary <(
    SELECT MAX(salary)
    FROM table)

  21. nivedan
    1
    Reply

    With SubQuery:

    SELECT salary from
    (SELECT salary FROM Employee ORDER BY salary DESC LIMIT 2)
    ORDER BY salary ASC LIMIT 1;

    Without SubQuery:

    SELECT salary
    FROM Employee
    ORDER BY salary DESC
    OFFSET 1 ROWS
    FETCH NEXT 1 ROWS ONLY;

  22. Shubham Bhatt
    0
    Reply

    Let us say we have an employee table with two columns namely ID, Salary. I would be writing a generalized query below for finding out the Nth highest salary. N could be anything 1,2,3…..

    select salary from employee e1 where N – 1 = (select count(distinct salary) from employee e2 where e2.salary > e1.salary)

    0
    Reply

    SELECT MAX(Salary) FROM TABLE
    WHERE Salary < (SELECT MAX(SALARY) FROM TABLE)

  24. Harshit Goyal
    0
    Reply

    SELECT MIN(Salary) FROM (SELECT Salary
    FROM emp
    ORDER BY Salary DESC
    LIMIT 2)

  25. diksha.aggarwal0394
    0
    Reply

    ELECT MAX(Salary) FROM TABLE
    WHERE Salary < (SELECT MAX(SALARY) FROM TABLE)

  26. Ritesh Jain
    0
    Reply

    SELECT MAX(Salary) From table WHERE Salary < ( SELECT Max(Salary) FROM table)

  27. Pranshi_20
    0
    Reply

    SELECT MAX(salary)
    FROM (SELECT salary FROM table WHERE (salary<MAX(salary)));

    0
    Reply

    SELECT MIN(salary)
    FROM table
    WHERE salary IN (
    SELECT DISTINCT(SALARY)
    FROM
    table
    ORDER BY salary DESC
    LIMIT 2
    )

    0
    Reply

    Select min(salary) from table where salary in
    (Select salary from table order by salary desc limit 2)

    0
    Reply

    SELECT MAX(salary) AS salary
    FROM employee
    WHERE salary < (SELECT MAX(salary)
    FROM employee);

  31. sharma7797kajal
    0
    Reply

    Select Max(Salary) from Employee
    where Salary <
    (Select Max(Salary) from Employee)

  32. Nitesh210
    0
    Reply

    select salary from table_name as t1
    where 1 = (select count(distinct salary) from table_name as t2
    where t2.salary>t1.salary)

  33. vignesh222022
    0
    Reply

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

Leave an answer

Browse
Browse