FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
LeetCode-Solutions/MySQL/second-highest-salary.sql at master · pythonpeixun/LeetCode-Solutions · GitHub
pythonpeixun
/
LeetCode-Solutions
Public
forked from
kamyu104/LeetCode-Solutions
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
second-highest-salary.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
7 lines (5 loc) · 258 Bytes
Breadcrumbs
LeetCode-Solutions
/
MySQL
/
second-highest-salary.sql
Copy path
File metadata and controls
7 lines (5 loc) · 258 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
#
Time: O(n)
#
Space: O(1)
SELECT
(
SELECT
MAX
(Salary)
FROM
Employee
WHERE
Salary NOT
IN
(
SELECT
MAX
(Salary)
FROM
Employee)) SecondHighestSalary;
#
or
SELECT
(
SELECT
Salary
FROM
Employee
GROUP BY
Salary
ORDER BY
Salary
DESC
LIMIT
1
,
1
) SecondHighestSalary;
Back
|
FazBrowse Home
|
New Git URL