SELECT to_char(czrq),
zdid,
SUM(czje)
FROM a
WHERE zdid = '001'
AND czrq >= (SELECT MAX(scsqsj) FROM b WHERE zdid = '001')
AND czrq <= SYSDATE
GROUP BY trunc(czrq)
zdid,
SUM(czje)
FROM a
WHERE zdid = '001'
AND czrq >= (SELECT MAX(scsqsj) FROM b WHERE zdid = '001')
AND czrq <= SYSDATE
GROUP BY trunc(czrq)
FROM a t2
WHERE zdid = '001'
AND trunc(t2.czrq) = trunc(t1.czrq)) '开始时间',
(SELECT MAX(t2.czrq)
FROM a t2
WHERE zdid = '001'
AND trunc(t2.czrq) = trunc(t1.czrq)) '结束时间',
t1.zdid,
SUM(t1.czje)
FROM a t1
WHERE t1.zdid = '001'
AND t1czrq >= (SELECT MAX(scsqsj) FROM b WHERE zdid = '001')
AND t1czrq <= SYSDATE
GROUP BY trunc(t1.czrq)