牛客404425958号

分类

/ 注册

全部文章（共214篇）

统计出当前各个title类型对应的员工当前薪水对应的平均工资

select distinct title, avg(salary) over(partition by title) avg_salary from titles left join salaries using(emp_no) order by avg_salary select...

2024-10-20

0 72

查employees表empno与lastname的员工信息

select * from employees where mod(emp_no,2)=1 and last_name!='mary' order by hire_date desc 求余数mod(被除数，除数)

2024-10-20

0 60

题解 | #获取每个部门中当前员工薪水最高的相关信息#

with t as( select emp_no, dept_no, salary, max(salary) over(partition by dept_no) as group_max from dept_emp left joi...

2024-10-20

0 56

题解 | #获取所有员工当前的manager#

select a.emp_no, b.emp_no as manager from dept_emp a left join dept_manager b on a.dept_no=b.dept_no where a.emp_no!=b.emp_no

2024-10-20

0 53

题解 | #获取所有非manager的员工emp_no#

select emp_no from employees left join dept_manager using(emp_no) where dept_no is null

2024-10-20

0 51

题解 | #找出所有员工当前薪水salary情况#

select distinct salary from salaries order by salary desc

2024-10-20

0 46

薪水记录超过15条的员工号emp_no以及其对应的记录次数t

select emp_no, count(salary) from salaries group by emp_no having count(salary)>15

2024-10-20

0 36

查找所有员工的lastnamefirstnamedeptno

select last_name, first_name, dept_no from employees left join dept_emp using(emp_no) /*employees 左连接 dept_emp，即以employees为基准输出数据（输出employees包含的数据）*/

2024-10-20

0 67

查找已分配部门员工lastfirstnamedeptno

select last_name, first_name, dept_no from employees right join dept_emp using(emp_no) /*employees 右连接 dept_emp，即以dept_emp为基准输出数据（仅输出de...

2024-10-20

0 56

题解 | #查找当前薪水详情以及部门编号dept_no#

select emp_no, salary, from_date, a.to_date, dept_no from salaries a join dept_manager b using(emp_no)

2024-10-19

0 53