最美情侣中文字幕电影,在线麻豆精品传媒,在线网站高清黄,久久黄色视频

歡迎光臨散文網(wǎng) 會(huì)員登陸 & 注冊

[Database-Leetcode]176. Second Highest Salary

2021-02-21 08:43 作者:您是打尖兒還是住店呢  | 我要投稿

Write a SQL query to get the second highest salary from the?Employee?table.

Employee

For example, given the above Employee table, the query should return?200?as the second highest salary. If there is no second highest salary, then the query should return?null.


answer

SELECT MAX(Salary) AS SecondHighestSalary FROM Employee

WHERE Salary < (SELECT MAX(Salary) FROM Employee);






[Database-Leetcode]176. Second Highest Salary的評論 (共 條)

分享到微博請遵守國家法律
中宁县| 彭山县| 石门县| 宁晋县| 阳信县| 开化县| 宜君县| 丹寨县| 横山县| 梓潼县| 建始县| 鸡西市| 孟村| 琼海市| 宝丰县| 包头市| 海原县| 广汉市| 白城市| 永昌县| 抚州市| 股票| 綦江县| 濉溪县| 临洮县| 织金县| 兰西县| 金川县| 牙克石市| 康定县| 开阳县| 怀仁县| 涟源市| 石河子市| 罗源县| 浦县| 且末县| 鄂托克旗| 虎林市| 济源市| 县级市|