我有一个表,其中有帐号,组类别和日期。我有一个执行此操作的查询 Select count(AccNum)Where date BETWEEN '2020-02-01' AND '2020-03-31'groupSelect count(AccNum) Where date between 2020-02-01 AND '2020-02-31' AS CountFebuary, count(AccNum) Where</em
我希望在一年内获得每天的数据,但我每天都必须使用365个查询,如下所示: $end_day = ...; // the end timeof each day $query = select count(*)....wherecreated < $end_day AND created > $start_day我认为我目前