复习:
MySQL语言执行顺序
from
on
join
where
group by (包含sum()等聚合函数)
having
select
distinct
union
order by
1 累加
1.1 基础累加
创建订单表
create table SC (id varchar(10),dt datetime(10),orderamt decimal(18,1));
insert into SC values('01' , '2018-01-01' , 2);
insert into SC values('02' , '2018-01-02' , 3);
insert into SC values('03' , '2018-01-03' , 5);
insert into SC values('04' , '2018-01-04' , 10);
select * from SC;
Output:
id | dt | orderamt |
---|---|---|
01 | 2018-01-01 | 2 |
02 | 2018-01-02 | 3 |
03 | 2018-01-03 | 5 |
04 | 2018-01-04 | 10 |
累加算法
• 使用不等值进行连接
• 执行顺序:先join on,再group by、sum
select a.id, a.dt, a.orderamt, sum(b.orderamt)