select 人数,FZ from (
select 人数,tt.rowncount,cretetime,CASE WHEN tt.rowncount = 1 THEN 0 ELSE (SELECT SUM(人数) FROM tablename s WHERE rownum<=tt.rowncount) end as fZ from (
select 人数,TO_CHAR(日期,'yyyy/MM/dd') as cretetime, rownum as rowncount from tablename t where TO_CHAR(日期,'yyyy/MM/dd')='2018/03/20'
) TT
union
select 人数,tt.rowncount,cretetime,CASE WHEN tt.rowncount = 1 THEN 0 ELSE (SELECT SUM(人数) FROM tablename s WHERE rownum<=tt.rowncount) end as fZ from (
select 人数, rownum as rowncount,TO_CHAR(日期,'yyyy/MM/dd') as cretetime from tablename t where TO_CHAR(日期,'yyyy/MM/dd')='2018/03/29'
) TT ) TTS order by TTS.cretetime,tts.rowncount