select billdate, sum([qty]) posinqty from rtldetail a,rtlbill b where a.billno = b.billno and billdate>=&#39;2009-09-25 00:00:00&#39; and billdate<=&#39;2012-09-25 23:59:59&#39; group by billdate order by billdate offset 10row fetch next20rows only;
(3)重启mariadb
(4)执行下面的分页语句
select billdate, sum(qty) as posinqty from rtldetail a,rtlbill b where a.billno = b.billno and billdate>=&#39;2009-09-25 00:00:00&#39; and billdate<=&#39;2012-09-25 23:59:59&#39; group by billdate order by billdate limit 10,20;