2005-5-3 5
-----------------------------------------------------------
日期 数值 累计
2005-5-2 2 4.4
2005-5-3 5 9.4
----------------------------------------------------------
sql语句实现:
SELECT aa.日期, aa.数值, SUM(lj.数值) AS 累计
FROM tb lj INNER JOIN
(SELECT * FROM tb) aa ON lj.日期 <= aa.日期
WHERE (aa.日期 <= '
GROUP BY aa.日期, aa.数值
ORDER BY aa.日期