mysql limit之后想统计查询出来的条数的某个字段和？

问题描述

问题解答

用子查询的方式来实现：

select uid, sum(skip) as sumskip, time from (select uid, skip, time from attendance where uid = 8499 order by time limit 3) as subt;