OkMaid

分类

题解(34)

/ 注册

全部文章（共70篇）

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

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 217

#查找薪水记录超过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

题解 | #查找最晚入职员工的所有信息#

select * from employees order by hire_date desc limit 1

Mysql

2022-09-15

1 267

题解 | #某乎问答单日回答问题数大于等于3个的所有用户#

select answer_date, author_id, count(issue_id) answer_cnt from answer_tb where month(answer_date) = 11 g...

Mysql

2022-09-15

0 253