五月天青色头像情侣网名,国产亚洲av片在线观看18女人,黑人巨茎大战俄罗斯美女,扒下她的小内裤打屁股

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

分享到微博請遵守國家法律
哈巴河县| 阳西县| 连州市| 于都县| 迁安市| 梁山县| 大埔区| 云梦县| 三门峡市| 马山县| 荣昌县| 且末县| 威远县| 建瓯市| 加查县| 东辽县| 夏津县| 北票市| 青田县| 临武县| 喜德县| 灵寿县| 朔州市| 阿坝| 理塘县| 白玉县| 福海县| 潢川县| 嵊州市| 河间市| 布拖县| 彩票| 望奎县| 镇康县| 红安县| 富平县| 栾城县| 德格县| 岑巩县| 北安市| 清水河县|