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

歡迎光臨散文網(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的評論 (共 條)

分享到微博請遵守國家法律
兴海县| 千阳县| 新蔡县| 长垣县| 上林县| 禄丰县| 大方县| 沙坪坝区| 安顺市| 西昌市| 天峨县| 廉江市| 会同县| 休宁县| 阿巴嘎旗| 壶关县| 特克斯县| 礼泉县| 庆安县| 腾冲县| 青州市| 双城市| 沿河| 贺州市| 明光市| 化隆| 文山县| 靖边县| 郓城县| 新宾| 成武县| 阳春市| 滦平县| 芦山县| 通化市| 荥经县| 罗甸县| 交口县| 临武县| 白沙| 东港市|