请结合下表业务说明,按照(交易日期)分组与按照(交易日期+用户ID)分组,在数据计算上的区别 CREATE TABLE IF NOT EXISTS trade_history ( BASE_DATE DATE NOT NULL comment '交易日期', SEQUENCE INT NOT NULL comment '交易序列号', USER_ID INT NOT NULL comment '用户ID', TRADE_AMOUNT INT NOT NULL comment '交易金额', PRIMARY KEY (BASE_DATE, SEQUENCE, USER_ID) ); insert into trade_history values ('2020-06-05', 1, 1, 100), ('2020-06-07', 1, 1, 200), ('2020-06-07', 2, 1, 150), ('2020-06-25', 1, 2, 100), ('2020-06-27', 1, 2, 200), ('2020-06-27', 2, 2, 250), ('2020-06-27', 3, 2, 120); select * from trade_history;
最新发布