Kaka777
Kaka777
全部文章
分类
个人题解笔记(1)
题解(12)
归档
标签
去牛客网
登录
/
注册
Kaka777的博客
全部文章
(共2篇)
题解 | #获取当前薪水第二多的员工的emp_no以及其对应的薪水salary#
So 1. In MySQL and SQL servers like PostgreSQL, AGG function and single columns cannot be selected at the same time unless the single columns are also...
GOUPBY
HAVING
NESTEDSELECT
2021-08-08
0
321
题解 | #获取每个部门中当前员工薪水最高的相关信息#
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
370