少糖去冰啊_

分类

/ 注册

全部文章（共67篇）

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

SELECT emp_no, salary FROM salaries WHERE salary = (SELECT DISTINCT salary FROM salaries ORDER BY salary desc limit 1,1) ORDER BY emp_no

2025-10-17

0 19

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

SELECT title, avg(s.salary) FROM titles t INNER JOIN salaries s on t.emp_no = s.emp_no GROUP BY title ORDER BY avg(salary)

2025-10-17

0 18

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

SELECT d.emp_no, d1.emp_no as manager FROM dept_emp d LEFT JOIN dept_manager d1 on d.dept_no=d1.dept_no where d.emp_no <> d1.emp_no

2025-10-17

0 18

题解 | 获取每个部门中薪水最高的员工相关信息

SELECT dept_no, d.emp_no, salary FROM dept_emp d LEFT JOIN salaries s on d.emp_no=s.emp_no WHERE (dept_no, salary) in (SELECT dept_no, max(salary) FR...

2025-10-17

0 19

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

SELECT e.emp_no FROM employees e LEFT JOIN dept_manager d on e.emp_no = d.emp_no where dept_no is null

2025-10-17

0 19

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

SELECT DISTINCT salary FROM salaries ORDER BY salary desc

2025-10-15

0 19

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

SELECT emp_no, count(*) as t FROM salaries GROUP BY emp_no HAVING t>15

2025-10-15

0 23

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

SELECT last_name, first_name, dept_no FROM employees e INNER JOIN dept_emp d on e.emp_no = d.emp_no

2025-10-15

0 18

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

SELECT s.emp_no, salary, from_date, s.to_date, dept_no FROM salaries s INNER JOIN dept_manager d on s.emp_no = d.emp_no ORDER bY s.emp_no asc

2025-10-15

0 18

题解 | 查找入职员工时间升序排名的情况下的倒数第三的员工所有信息

SELECT * FROM employees WHERE hire_date = (SELECT hire_date FROM employees GROUP BY hire_date Order by hire_date desc LIMIT 2,1) Order BY emp_no asc

2025-10-15

0 20