biubiubiu~~~~

分类

题解(44)

/ 注册

全部文章（共43篇）

题解 | #考试分数(五)#

select t.id, t.job, t.score, t.t_rank from (select id, job, score, count(id) over(partition by job) cnt, ...

Mysql

2021-11-08

0 426

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

本题解析这是一题求第几名的题目,平时用order by和limit比较好解决,不用的话求起来比较麻烦,也不太好理解,不过多操作几次就明白了参考答案 select e.emp_no, s.salary, e.last_name, e.first_name from employees e jo...

Mysql

2021-11-07

0 395

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

参考答案 select music_name from music where id in ( select music_id from music_likes where user_id in( select follower_id from follow where user...

Mysql

2021-11-06

2 462

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

参考答案 select g.id, g.name, g.weight, t2.total from goods g , ( select goods_id, sum(t.count) total from trans t group...

Mysql

2021-11-06

0 439

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

参考答案 select u.id, u.name, t.grade_sum grade_sum from user u,( select user_id, sum(if(type='add',grade_num,-grade_num)) grade_sum, dense_...

Mysql

2021-11-06

0 401

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

参考答案 select u.id,u.name,sum(g.grade_num) grade_sum from user u join grade_info g on u.id=g.user_id group by u.id having grade_sum = (select sum(grad...

Mysql

2021-11-06

0 369

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

参考答案 select u.name, sum(grade_num) grade_num from grade_info g right join user u on u.id = g.user_id group by user_id order by grade_num desc lim...

Mysql

2021-11-06

0 306

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

参考答案 select grade from ( select grade, (select sum(number) from class_grade) as total, sum(number) over(order by grade) a, sum(n...

Mysql

2021-11-06

0 370

题解 | #实习广场投递简历分析(三)#

参考答案 select s1.job, left(s1.date,7) as 'first_year_mon', s1.cnt as'first_year_cnt', left(s2.date,7) as 'second_year_mon', s2.cnt as 'second_year_cnt'...

Mysql

2021-11-06

0 395

题解 | #实习广场投递简历分析(二)#

参考答案 select job, left(date,7) as 'mon', sum(num) as 'cnt' from resume_info ri1 where date between '2025-01-01' and '2026-01-01' group by job,mon...

Mysql

2021-11-06

0 441