9 lines
143 B
MySQL
9 lines
143 B
MySQL
|
SELECT (
|
||
|
|
SELECT salary
|
||
|
|
FROM Employee
|
||
|
|
GROUP BY salary
|
||
|
|
ORDER BY salary DESC
|
||
|
|
LIMIT 1
|
||
|
|
OFFSET 1
|
||
|
|
) AS "SecondHighestSalary";
|