牛客365029791号

分类

题解(6)

/ 注册

全部文章（共4篇）

题解 | #分页查询employees表，每5行一页，返回第2页的数据#

select * from employees limit 5,5; select *from employees awhere emp_no>=(select emp_no from employees limit 5,1)limit 5;

2021-08-04

0 278

题解 | #汇总各个部门当前员工的title类型的分配数目#

select a.dept_no,d.dept_name,a.title,a.countfrom departments dleft join(select de.dept_no,t.title,count(t.emp_no) as countfrom dept_emp deleft join ti...

2021-08-03

0 259

题解 | #获取员工其当前的薪水比其manager当前薪水还高的相关信息#

select d.emp_no,d.manager_no,d.emp_salary,d.manager_salaryfrom(select c.emp_no,c.manager_no,c.salary emp_salary,s2.salary manager_salary from (sele...

2021-08-03

0 199

题解 | #统计各个部门的工资记录数#

select a.dept_no,a.dept_name,c.sumfrom departments aleft join(select d.dept_no,count(s.emp_no) as sumfrom dept_emp dinner join salaries son d.emp_no=s...

2021-08-02

0 264