牛客939883218号

分类

题解(6)

/ 注册

全部文章（共2篇）

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

with t As ( select *,row_number() over(partition by job order by score desc) r_rank from grade) select t.id,t.job,t.score,t.r_rank from t left join (...

Mysql

2021-09-27

0 269

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

select l1.date,count(distinct case when l2.user_id IS null then l1.user_id else null end) from login l1 left join login l2 on l1.user_id=l2.user_id an...

Mysql

2021-09-17

0 249