会编程的发呆爱好者加麻加辣

分类

/ 注册

全部文章（共208篇）

题解 | 每个月Top3的周杰伦歌曲

select month,ranking,song_name,play_pv from( select month(p.fdate) as month, row_number() over (partition by month(p.fdate) order by count(p.s...

2025-04-01

0 33

题解 | 今天的刷题量(一)

select a.name,a.cnt from ( SELECT s.subject_id,ss.name, count(*) as cnt from submission s join subject ss on s.subject_id = ss.id ...

2025-03-31

0 23

题解 | 查找最晚入职员工的所有信息

select emp_no,birth_date,first_name,last_name,gender,hire_date from employees order by hire_date desc limit 1 简单

2025-03-31

0 35

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

with a as ( #自己喜欢的音乐 select id,music_name from music where id in (select music_id from music_likes where user_id =1) ), b as( #关注的人喜欢的音乐 select id...

2025-03-31

0 42

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

select g.id,g.name,g.weight, sum(t.count) as total from goods g join trans t on g.id = t.goods_id group by g.id having total>=20 and g.weight<=...

2025-03-31

0 36

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

select distinct id,name, grade_num from( select id,name, dense_rank() over (order by grade_num desc) as rk,grade_num from( SELECT u.id, u.na...

2025-03-29

0 24

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

select distinct id,name, grade_num from( select id,name, dense_rank() over (order by grade_num desc) as rk,grade_num from( select u.id,u.name,sum(...

2025-03-29

0 21

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

select name, grade_num from( select name, row_number() over (order by grade_num desc) as rk,grade_num from( select u.id,u.name,sum(g.grade_num) ov...

2025-03-29

0 30

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

select grade from (select grade,(select sum(number) from class_grade) as total, sum(number) over(order by grade) a, sum(number) over(o...

2025-03-28

0 30

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

select grade, sum(number) over(order by grade) as t_rank from class_grade order by grade sum(number) over(order by grade) as t_rank

2025-03-28

0 25