表sutraRecord
CREATE TABLE sutraRecord
(id
int(11) NOT NULL AUTO_INCREMENT,pID
varchar(3) NOT NULL,sutraID
int(11) NOT NULL,sutraNote
int(11) NOT NULL,updatetime
datetime NOT NULL,
PRIMARY KEY (id
)
)
insert into sutraRecord values ('1','001','1','1','2018-10-17');
insert into sutraRecord values ('2','001','2','1','2018-10-18');
insert into sutraRecord values ('3','001','3','1','2018-10-19');
insert into sutraRecord values ('4','002','1','1','2018-10-15');
insert into sutraRecord values ('5','002','2','1','2018-10-16');
insert into sutraRecord values ('6','002','3','1','2018-10-16');
insert into sutraRecord values ('7','002','4','1','2018-10-17');
insert into sutraRecord values ('8','003','1','1','2018-10-18');
insert into sutraRecord values ('9','004','1','1','2018-10-17');
insert into sutraRecord values ('10','004','2','1','2018-10-17');
insert into sutraRecord values ('11','005','5','1','2018-10-18');
我想要
pID,sumNote
001 3
002 3
003 1
004 1
005 1
在此先行谢谢了,