SQL实战71.牛客每个人最近的登录日期(六)

题目

在这里插入图片描述

解答

注意:增加条件算累和

select u.name as u_n,t.date,t.ps_num
from (select pn1.user_id,pn1.date,
(select sum(pn2.number) from passing_number as pn2  
where pn1.date >= pn2.date 
and pn1.user_id = pn2.user_id) as ps_num
from passing_number as pn1) as t       
left join user as u on t.user_id=u.id
order by date,u_n;

自己想法:

select u.name u_n,ps1.date,(select sum(ps2.number)
                            from passing_number as ps2
                            where ps2.user_id = ps1.user_id 
                            and ps2.date<=ps1.date) as ps_num
from passing_number as ps1 join user u on u.id = ps1.user_id
order by date,u_n;
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值