随笔分类 -  Mysql

LC177-第N高的薪水
摘要：177. 第N高的薪水 CREATE FUNCTION getNthHighestSalary(N INT) RETURNS INT BEGIN declare m int; set m = N - 1; RETURN ( # Write your MySQL query statement bel 阅读全文
posted @ 2021-08-06 21:03 Ivessas 阅读(23) 评论(0) 推荐(0)
LC176-第二高的薪水
摘要：176. 第二高的薪水 # Write your MySQL query statement below select ifnull( (select distinct(salary) # distinct 用于去重 from Employee order by Salary desc # 降序排列 阅读全文
posted @ 2021-08-06 21:00 Ivessas 阅读(36) 评论(0) 推荐(0)