GB279824

分类

/ 注册

全部文章（共190篇）

题解 | 获取所有员工当前的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 29

题解 | 获取所有非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 26

题解 | 查找所有员工的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 25

题解 | 查找所有已经分配部门的员工的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 37

题解 | 查找当前薪水详情以及部门编号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 30

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

# 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 36

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

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

2025-05-23

0 30

题解 | 纠错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 28

题解 | 组合 Products 表中的产品名称和 Customers 表中的顾客名称

# select prod_name from Products # union all # select cust_name as prod_name from Customers # order by prod_name ASC; # select prod_name from Produc...

2025-05-21

0 42

题解 | 将两个 SELECT 语句结合起来（二）

select prod_id,quantity from OrderItems where quantity = 100 or prod_id like 'BNBG%' order by prod_id ASC;

2025-05-21

0 34