Dashboard Temp Share Shortlinks Frames API

HTMLify

Day 19
Views: 19 | Author: djdj
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
/*
	https://leetcode.com/problems/second-highest-salary/
*/

# Write your MySQL query statement below
select 
  (select distinct salary as SecondHighestSalary 
    from Employee
    order by salary 
    desc limit 1,1) 
    as SecondHighestSalary;