insert into order_table VALUES(1,001,100,'2018-01-01 00:00:00');
insert into order_table VALUES(2,001,300,'2018-01-02 00:00:00');
insert into order_table VALUES(3,001,500,'2018-01-02 00:00:00');
insert into order_table VALUES(4,001,800,'2018-01-03 00:00:00');
insert into order_table VALUES(5,001,900,'2018-01-04 00:00:00');
insert into order_table VALUES(6,002,500,'2018-01-03 00:00:00');
insert into order_table VALUES(7,002,600,'2018-01-04 00:00:00');
insert into order_table VALUES(8,002,300,'2018-01-10 00:00:00');
insert into order_table VALUES(9,002,800,'2018-01-16 00:00:00');
insert into order_table VALUES(10,002,800,'2018-01-22 00:00:00');
按照功能划分,可以把MySQL支持的窗口函数分为如下几类:
- 序号函数:r