Problem
Write a SQL query to get the second highest salary from the Employee table.
+----+--------+
| Id | Salary |
+----+--------+
| 1 | 100 |
| 2 | 200 |
| 3 | 300 |
+----+--------+
For example, given the above Employee table, the second highest salary is 200. If there is no second highest salary, then the query should return null.
Code
select max(Salary) from Employee where Salary < (select max(Salary) from Employee);
ProblemWrite a SQL query to get the second highest salary...
176. Second Highest Salary Description Write a SQL query ...
Write a SQL query to get the second highest salary from t...
目录 175 Combine Two Tables E 176 Second Highest Salary ...
LeetCode176. Second Highest Salary 题目 Write a SQL query t...
中文题目 写一个 SQL 查询语句，获取 Employee 表中第二高的Salary 。 +----+-----...
t 175. Combine Two Tables t 176. Second Highest Salary t ...
没有找到怎么按照mysql高亮显示... left join的使用 Second Highest Salary: ...
题目链接： 176. Second Highest Salary 解析： 看到这道题，我刚开始的想法是使用ORDE...
语言：sql v1: 结果：未通过，因为为空时，和期待的结果null不同v2:
本文标题：Second Highest Salary
本文链接：https://www.haomeiwen.com/subject/knjlfttx.html
网友评论