56,687
社区成员
发帖
与我相关
我的任务
分享
SELECT SUM(points) points
FROM ( SELECT class ,
name ,
createdate ,
points
FROM ( SELECT *
FROM tb
WHERE class = '一班'
AND createdate <= '20160229'
ORDER BY class ,
name ,
createdate DESC
) t
GROUP BY class ,
name
) t