GB279824

分类

/ 注册

全部文章（共162篇）

题解 | 查找employees表emp_no与last_name的员工信息

select * from employees where emp_no % 2 <> 0 and last_name <> 'Mary' order by hire_date DESC;

2025-05-23

0 22

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

select dept_no, s.emp_no, salary from dept_emp e left join salaries s on e.emp_no=s.emp_no where (dept_no,salary) in ( select dept_no,max...

2025-05-23

0 24

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

select e.emp_no as emp_no, d.emp_no as manager from dept_emp e left join dept_manager d on e.dept_no = d.dept_no where e.emp_no != d.emp_n...

2025-05-23

0 18

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

select e.emp_no from employees e left join dept_manager d on e.emp_no = d.emp_no where dept_no is null;

2025-05-23

0 15

题解 | 查找所有员工的last_name和first_name以及对应部门编号dept_no

select last_name,first_name,dept_no from employees e left join dept_emp d on e.emp_no = d.emp_no;

2025-05-23

0 15

题解 | 查找所有已经分配部门的员工的last_name和first_name以及dept_no

select last_name, first_name, dept_no from employees e left join dept_emp d on e.emp_no = d.emp_no where dept_no is not null;

2025-05-23

0 19

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

select s.emp_no, salary, from_date, s.to_date, dept_no from salaries s left join dept_manager m on s.emp_no = m.emp_no where dept_no i...

2025-05-23

0 15

题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

# select * # from employees # order by # hire_date DESC # limit 2,1; select a.emp_no,a.birth_date,a.first_name,a.last_name,a.gender,a.hire_d...

2025-05-23

0 19

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

# select * # from employees # where hire_date in ( # select max(hire_date) # from employees # ) # select * # from employees # where hire_dat...

2025-05-23

0 16

题解 | 纠错4

SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email FROM Customers ...

2025-05-21

0 15