我能找到工作吗？

分类

题解(26)

/ 注册

全部文章（共7篇）

题解 | #对所有员工的薪水按照salary降序进行1-N的排名#

判断是否为NULL用is select f.film_id,f.title from film f left join film_category fi on f.film_id=fi.film_id where fi.category_id is NULL;

Sqlite

2021-10-08

0 278

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

select d.dept_no,d.dept_name,count(*) sum from (departments d inner join dept_emp de on d.dept_no=de.dept_no) t inner join salaries s on t.emp_no=s...

Sqlite

2021-10-06

0 270

题解 | #查找所有员工的last_name和first_name以及对应的dept_name#

select last_name,first_name,dept_name from (employees e left join dept_emp d on e.emp_no=d.emp_no) t left join departments de on t.dept_no=de.dept_no;

Sqlite

2021-10-06

0 278

题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#

不同类型用group by先分组，再用order by排序 select t.title,avg(s.salary) as average from titles as t join salaries as s on t.emp_no = s.emp_no group by t.title ord...

Sqlite

2021-10-06

0 336

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

select dept_emp.emp_no as emp_no, dept_manager.emp_no as manager_no from dept_emp, dept_manager where dept_emp.dept_no=dept_manager.dept_no and dept_e...

Sqlite

2021-10-06

1 301

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

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

Sqlite

2021-10-06

1 246

题解 | #查找入职员工时间排名倒数第三的员工所有信息#

select * from (select * from employees order by hire_date desc limit 3) order by hire_date limit 1;

Sqlite

2021-10-06

1 222