上面语句刚打错了,不号意思
select count(*) as c from A where (select sum(Score) from A where substring(gamedate,1,7)='2005-11' group by username)>30
或
select sum(Score) as s from (select * from A where substring(game,1,7)='2005-11') group by username having sum(Score)>30
然后再查出记录数目都查出有错
select count(*) as c from A where (select sum(Score) from A where substring(gamedate,1,7)='2005-11' group by username)>30
或
select sum(Score) as s from (select * from A where substring(game,1,7)='2005-11') group by username having sum(Score)>30
然后再查出记录数目都查出有错
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货