OkMaid

分类

题解(34)

/ 注册

全部文章（共68篇）

获取当前薪水第二多的员工的emp_no以及其对应的薪水

select emp_no,salary from (select emp_no,salary,rank() over(order by salary desc) t from salaries where to_date='9999-01-01') t1 where t=2

2022-11-19

0 226

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

select t.title, avg(s.salary) from salaries s join titles t using(emp_no) group by t.title order by avg(s.salary)

2022-11-19

0 278

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

select dept_no, t1.emp_no, maxSalary from(select dept_no, t1.emp_no, salary as maxSalary, rank() over(par...

Mysql

2022-10-13

0 263

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

select t1.emp_no, t2.emp_no as manager from dept_emp t1 left join dept_manager t2 on t1.de...

Mysql

2022-10-13

0 319

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

select emp_no from employees where emp_no not in (select distinct emp_no &...

Mysql

2022-10-13

0 216

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

select emp_no, t from (select emp_no, count(*) as t from salaries &n...

Mysql

2022-10-13

0 271

题解 | #查找所有员工的last_name

select last_name, first_name, dept_no from employees t1 left join dept_emp t2 on t1.emp_no ...

Mysql

2022-10-13

0 265

题解 | #查找所有已经分配部门的员工

select last_name, first_name, t1.dept_no from dept_emp t1 left join employees t2 on t1.emp_no&n...

Mysql

2022-10-13

0 271

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

select t2.emp_no, salary, from_date, t2.to_date, dept_no from dept_manager t1 left join salaries&nbs...

Mysql

2022-10-13

0 326

题解 | #查找入职员工时间排名倒数第三的员工所有信息#

SELECT * FROM employees WHERE hire_date = ( SELECT DISTINCT hire_date &nb...

Mysql

2022-09-18

0 259