2htttttttttt
2htttttttttt
全部文章
分类
题解(2)
归档
标签
去牛客网
登录
/
注册
2htttttttttt的博客
全部文章
(共2篇)
题解 | #某宝店铺连续2天及以上购物的用户及其对应的天数#
select user_id,max(total) as days_count from ( select *,dense_rank() over (partition by user_id order by sales_date range between interval 1 day prece...
Mysql
2022-05-30
0
156
题解 | #考试分数(五)#
select b.id,b.job,b.score, b.rkfrom(select ,rank() over (partition by job order by score desc) as rkfrom grade) as bJOIN(select g.id,g.job,g.score,a.m...
2021-08-11
0
327