Monthly Archives: January 2021

MySQL 'group by' together with 'partition by' Online MySQL Database create table Test(cc varchar(25), item varchar(100), num integer); insert into Test(cc, item, num) values('ca', '8.1.4', 11); insert into Test(cc, item, num) values('cn', '8.1.1', 1); insert into Test(cc, item, num) values('cn', '8.1.4', 15); insert into Test(cc, item, num) values('cn', '8.1.3', 5); insert into Test(cc, item, [...]