万能的窗口函数
牛客每个人最近的登录日期(六)
http://www.nowcoder.com/questionTerminal/572a027e52804c058e1f8b0c5e8a65b4
窗口函数 + join + 子查询
select u.name as u_n, t.date, t.ps_num from (select *, sum(number)over(partition by user_id order by date) as ps_num from passing_number ) t join user u on t.user_id = u.id order by t.date,u.name;
查看16道真题和解析
投递曼伦商贸等公司6个岗位 >