heyboysay

分类

未归档(1) 题解(2)

/ 注册

全部文章（共24篇）

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

select * from employees where emp_no % 2 <> 0 and last_name not like '%Mary%' order by hire_date desc

2025-04-26

0 101

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

select emp_no from employees where emp_no not in ( select emp_no from dept_manager )

2025-04-24

0 87

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

select distinct(salary) from salaries order by salary desc

2025-04-23

0 92

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

select emp_no , count(*) as t from salaries group by emp_no having count(*) > 15

2025-04-23

0 88

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

select e.last_name , e.first_name , coalesce(d.dept_no ,null) as dept_no from employees e left join dept_emp d on e.emp_no = d.emp_no

2025-04-23

0 65

题解 | 查询培训指定课程的员工信息

select s.staff_id , s.staff_name from staff_tb s inner join cultivate_tb c on s.staff_id = c.staff_id where c.course like '%course3%'

2025-04-23

0 68

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

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

2025-04-22

0 62

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

select s.emp_no , s.salary , s.from_date , s.to_date , d.dept_no from salaries s inner join dept_manager d on s.emp_no = d.emp_no ...

2025-04-22

0 66

题解 | 查询产生理赔费用的快递信息

select et.exp_number , et.exp_type , ec.claims_cost from express_tb et inner join exp_cost_tb ec on et.exp_number = ec.exp_number where e...

2025-04-22

0 53

题解 | 商品交易(网易校招笔试真题)

select g.id , g.name , g.weight , sum(t.count) as total from goods g inner join trans t on g.id = t.goods_id where g.weight < 50 gr...

2025-04-21

0 77