#121. [LeetCode / MySQL] 176. Second Highest Salary

문제

 

 

입력 코드

1. 

SELECT (
    SELECT DISTINCT Salary 
    FROM Employee
    ORDER BY salary DESC
    LIMIT 1
    OFFSET 1) AS SecondHighestSalary

 

 

2. 

SELECT DISTINCT MAX(salary) AS SecondHighestSalary 
FROM Employee
WHERE salary < (SELECT MAX(salary)
                FROM Employee)

 

 

코드 설명

#SELECT #DISTINCT #ORDER BY #DESC #LIMIT #OFFSET #MAX 

 

 

문제 출처

https://leetcode.com/problems/second-highest-salary/description/?envType=study-plan-v2&envId=top-sql-50