创建表:
create table test(date datetime,
userid varchar(2),
amount int)
insert into test values ('2018-10-02 00:00:00','u1',20)
insert into test values ('2018-10-02 21:09:28','u2',20)
insert into test values ('2018-10-02 21:09:29','u3',30)
insert into test values ('2018-10-03 21:36:44','u1',20)
insert into test values ('2018-10-03 21:36:46','u2',72)
insert into test values ('2018-10-03 21:36:52','u3',30)
insert into test values ('2018-10-30 21:36:54','u1',10)
insert into test values ('2018-10-30 21:36:57','u2',10)
执行:
select a.date,a.userid,a.amount,sum(b.amount) from test a,test b where a.userid=b.userid and a.date>=b.date group by a.date,a.userid,a.amount结果:
参考文档:https://blog.csdn.net/homechao/article/details/81207551?utm_medium=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-1.control&depth_1-utm_source=distribute.pc_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromMachineLearnPai2%7Edefault-1.control
https://blog.csdn.net/chongmu2584/article/details/100738740?utm_medium=distribute.pc_relevant.none-task-blog-baidujs_title-0&spm=1001.2101.3001.4242
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)