孤独的托尼给你点了个赞

分类

/ 注册

全部文章（共16篇）

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

select n.dept_no,n.dept_name,title,count(title) from departments n join dept_emp d using(dept_no) join titles using(emp_no) group by n.dept_no,title o...

2024-08-27

0 130

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

select s1.emp_no,(s1.salary-s2.salary) as growth from (select emp_no,salary from salaries where to_date='9999-01-01') s1---------在职员工涨薪后工资表 join (sel...

2024-08-26

3 124

查找所有员工的last_name和first_name

select last_name,first_name,dept_name from employees e left join dept_emp d on e.emp_no=d.emp_no left join departments n on d.dept_no=n.dept_no 多表连接时在...

2024-08-26

0 230

获取当前薪水第二多的员工的emp_no以及其对应的薪水

select employees.emp_no,salary,last_name,first_name from employees join salaries on employees.emp_no=salaries.emp_no where salary=( select max(salary)...

2024-08-25

0 146

获取当前薪水第二多的员工的emp_no的薪水salary

select emp_no ,salary from salaries where salary=( select distinct salary from salaries order by salary desc limit 1,1 ) order ...

2024-08-24

0 113

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

select emp_no,birth_date,first_name,last_name,gender,hire_date from (select *,dense_rank()over(order by hire_date desc) 排名 from employees) rk where rk...

2024-08-22

1 144