leetcode
文章平均质量分 71
米勒111
数据分析学习ing
展开
-
leetcode (难度)
185. 部门工资前三高的所有员工法一(开窗函数):selectd.nameasdepartment,e.nameasemployee,e.salaryfrom(select*,dense_rank()over(partitionbydepartmentidorderbysalarydesc)rankingfromemployee)ejoindepartmentdone.departmentid=d.idwheree.ran...原创 2021-07-29 19:47:42 · 71 阅读 · 0 评论 -
leetcode sql(中等)
177. 第N高的薪水CREATEFUNCTIONgetNthHighestSalary(NINT)RETURNSINTBEGINdeclaremINT;setm=N-1;RETURN(#WriteyourMySQLquerystatementbelow.selectifnull((selectdistinctsalaryfromEmployeeorderbysalarydesclimitm,1),...原创 2021-07-21 10:34:01 · 87 阅读 · 0 评论 -
leetcode sql(简单)
175. 组合两个表selectP.firstname,p.lastname,a.city,a.statefromPersonPleftjoinAddressaonp.PersonId=a.PersonId176. 第二高的薪水select(selectdistinctSalaryfromEmployeeorderbySalarydesclimit1,1)asSecondHighestSalary.(当Employee表里只有一条数据时,...原创 2021-07-20 11:05:00 · 163 阅读 · 0 评论