1.求累加
写出一个sql语句查询刷题信息,包括: 用户的id,以及截止到某天,累计总共通过了多少题
第一种方法,利用子查询表示累加字段:
select p1.user_id,p1.date,
(select sum(p2.number) from passing_number as p2
where p1.user_id=p2.user_id and p1.date>=p2.date) as ps_num
from passing_number as p1
第二种方法,利用窗口函数:
select pn.user_id,pn.date,
sum(number) over(partition by pn.user_id order by pn.date) as pn_num
from passing_number pn