SELECT T1.日期, T1.借, T1.贷, T2.余额 FROM(SELECT 日期, SUM(借) AS 借, SUM(贷) AS 贷 FROM TABLE WHERE 日期>=IN_STARTDATE and 日期=IN_STARTDATE and 日期=IN_STARTDATE and 日期
显示全部
SELECT T1.日期, T1.借, T1.贷, T2.余额
FROM
(SELECT 日期, SUM(借) AS 借, SUM(贷) AS 贷
FROM TABLE
WHERE 日期>=IN_STARTDATE and 日期<=IN_ENDDATE
GROUP BY 日期)T1,
(SELECT 日期, SUM(余额) AS 余额
FROM TABLE
WHERE 日期>=IN_STARTDATE and 日期<=IN_ENDDATE
AND (日期,ROW_ID) IN
(SELECT 日期, MAX(ROW_ID) AS ROW_ID
FROM TABLE
WHERE 日期>=IN_STARTDATE and 日期<=IN_ENDDATE
GROUP 日期, 科目)) T2
WHERE T1.日期 = T2.日期;
[
本帖最后由 骑猪撞上墙 于 2009-7-16 15:15 编辑 ]
收起