牛客593719959号

题解

/ 注册

全部文章 / 题解（共56篇）

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

sql script select de.dept_no, d.dept_name, t.title, count(*) from departments d, dept_emp de, titles t where d.dept_no=de.dept_no and de.emp_no=t.em...

sql

2021-09-01

0 320

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

sql script # employees salary with departments # select de.emp_no as emp_no, de.dept_no, s.salary as salary # from dept_emp de,salaries s # where de.e...

sql

2021-08-31

0 320

题解 | #获取所有非manager员工当前的薪水情况#

sql script select de.dept_no, e.emp_no, s.salary from employees e, dept_emp de, salaries s where e.emp_no=de.emp_no and e.emp_no=s.emp_no and e.emp_n...

sql

2021-08-31

0 301

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

sql script select emp_no, salary, dense_rank() over(order by salary desc) as t_rank from salaries key point dense_rank() function

sql

2021-08-31

0 264

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

sql script select d.dept_no, d.dept_name, count(s.emp_no) as sum from departments d, dept_emp de, salaries s where d.dept_no=de.dept_no and de.emp_no...

sql

2021-08-31

0 325

题解 | #查找在职员工自入职以来的薪水涨幅情况#

sql script # entry salary select e.emp_no, s.salary from employeess e, salaries s where e.emp_no=s.emp_no and e.hire_date=s.from_date # dimission s...

sql

2021-08-30

0 355