我的名字在哪里

分类

/ 注册

全部文章（共44篇）

题解 | 网易云音乐推荐(网易校招笔试真题)

SELECT music_name FROM ( SELECT DISTINCT ml.music_id, m.music_name FROM follow f JOIN music_likes ml ON f.follower_id = ml.user_id JOIN music m ON...

2026-04-08

0 31

题解 | 获得积分最多的人(三)

SELECT u.id, u.name, t.grade_num FROM user u JOIN ( SELECT user_id, SUM( CASE ...

2026-04-07

0 19

题解 | 最差是第几名(二)

select grade from ( select grade, sum(number) over ( order by grade asc ...

2026-04-07

0 17

题解 | 给出employees表中排名为奇数行的first_name

SELECT e.first_name FROM employees e JOIN ( SELECT first_name, DENSE_RANK() OVER (ORDER BY first_name) rk FROM employees ) t O...

2026-04-07

0 21

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

SELECT em.emp_no, sa.salary, em.last_name, em.first_name FROM employees em JOIN salaries sa USING (emp_no) WHERE salary in...

2026-04-07

0 17

题解 | 使用含有关键字exists查找未分配具体部门的员工的所有信息。

select * from employees where not exists ( select emp_no from dept_emp where employees.emp_no = dept_emp.emp_no );

2026-04-07

0 19

题解 | 考试分数(二)

SELECT g.id, g.job, g.score FROM( SELECT *, AVG(score) OVER(PARTITION BY job ) avg FROM grade ) g WHERE g.score > g.avg ORDER BY g.id; SELECT...

2026-04-04

0 19

题解 | 牛客每个人最近的登录日期(一)

SELECT user_id, date FROM ( SELECT user_id, date , DENSE_RANK() OVER (PARTITION BY user_id ORDER BY date DESC) rk FROM login ) e WH...

2026-04-04

0 22

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

SELECT e.dept_no, e.emp_no, e.salary FROM( SELECT de.dept_no, de.emp_no, s.salary, DENSE_RANK() OVER(PARTITION BY de.dept_no ...

2026-04-04

0 24

题解 | 确定哪些订单购买了 prod_id 为 BR01 的产品（一）

SELECT cust_id, order_date FROM Orders WHERE order_num IN ( SELECT order_num FROM OrderItems ...

2026-04-04

0 22