白色森林

分类

/ 注册

全部文章（共49篇）

题解 | 哪些产品在特定时间段内表现最为出色

WITH sales_total AS ( SELECT p.product_id, p.product_name, SUM(s.sales_amount) AS total_sales_amount, SUM(s.sales_...

2025-08-21

1 37

题解 | 牛客的课程订单分析(一)

SELECT * FROM order_info WHERE date>'2025-10-15' AND status='completed' AND product_name IN ('C++','Java','Python') ORDER BY id ASC...

2025-08-21

0 27

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

SELECT e.last_name, e.first_name, dm.dept_name FROM employees AS e LEFT JOIN dept_emp AS de ON e.emp_no=de.emp_no LEFT...

2025-08-21

1 33

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

SELECT e.emp_no, s.salary, e.last_name, e.first_name FROM employees AS e INNER JOIN salaries AS s ON e.emp_no=s.emp_no WHE...

2025-08-21

1 27

题解 | 统计salary的累计和running_total

WITH salary_total AS ( SELECT emp_no, SUM(salary) AS salary FROM salaries WHERE ...

2025-08-21

1 29

题解 | 出现三次以上相同积分的情况

SELECT number FROM grade GROUP BY number HAVING COUNT(number)>=3 ORDER BY number ASC;

2025-08-21

1 26

题解 | 商品交易(网易校招笔试真题)

WITH goodstotal AS( SELECT g.id, SUM(t.count) AS total FROM goods AS g INNER JOIN trans AS t ON g.id=t.goods_id GROUP BY g.i...

2025-08-21

1 40

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

SELECT dm.dept_no, dm.dept_name, COUNT(*) AS sum FROM departments AS dm INNER JOIN dept_emp AS de ON dm.dept_no=de.dept_no ...

2025-08-20

1 34

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

SELECT emp_no, salary FROM ( SELECT emp_no, salary, DENSE_RANK() OVER (ORDER BY salary DESC ) ...

2025-08-20

1 24

题解 | 查找employees表emp_no与last_name的员工信息

SELECT * FROM employees WHERE MOD(emp_no,2)=1 AND last_name<>'Mary' ORDER BY hire_date DESC;

2025-08-20

1 28