奋斗牛牛
奋斗牛牛
全部文章
分类
题解(14)
归档
标签
去牛客网
登录
/
注册
奋斗牛牛的博客
全部文章
(共4篇)
题解 | #网易云音乐推荐(网易校招笔试真题)#
not in 方法 select distinct music_name from follow f,music_likes ml,music m where f.follower_id=ml.user_id and ml.music_id=m.id and f.user_id=1 and musi...
Mysql
2021-10-02
0
252
题解 | #商品交易(网易校招笔试真题)#
第一个时使用聚合函数sum SELECT g.id,g.name,g.weight,t.total FROM goods g,( select goods_id,sum(count) total from trans group by goods_id ) t WHERE...
Mysql
2021-10-01
0
393
题解 | #考试分数(四)#
# 修改了一下大神的代码 SELECT job, floor((count(*)+1)/2) start , ceiling((count(*)+1)/2) end from grade group by job order by job; #使用窗口函数 SEL...
Mysql
2021-09-17
0
328
题解 | #牛客每个人最近的登录日期(五)#
select u.name u_n,p.date date, sum(p.number) over (partition by u.name rows between unbounded preceding and current...
Mysql
2021-09-17
0
308