Kaka777
Kaka777
全部文章
分类
个人题解笔记(1)
题解(12)
归档
标签
去牛客网
登录
/
注册
Kaka777的博客
全部文章
(共2篇)
题解 | #获取每个部门中当前员工薪水最高的相关信息#
Step1: it is straightforward to use INNER JOIN to collect all required info from given tables. So we could create one table just containing the result...
SQL
GOUPBY
TWOTABLES
2021-08-07
2
369
所有员工的当前(to_date='9999-01-01')薪水按照salary进行按照1-N的排名
不使用窗口函数 -- rank排名:查询表中大于自己薪水的员工的数量(考虑并列:去重) SELECT s1.emp_no, s1.salary, (SELECT COUNT(DISTINCT s2.salary) FROM salaries s2 WHER...
SQL
2020-10-11
98
4950