congr / world

2 stars 1 forks source link

LeetCode : 176. Second Highest Salary #379

Closed congr closed 6 years ago

congr commented 6 years ago

https://leetcode.com/problems/second-highest-salary/description/

image

congr commented 6 years ago

AC

# Write your MySQL query statement below
Select 
(Select Distinct Salary 
from Employee
order by Salary desc
limit 1 offset 1) as SecondHighestSalary 
;