oracle报表经典语句.docVIP

oracle报表的典型sql语句 分类:学习天地 Select LEAD(m.app_no,(Select Count(1) From app_mtfeature Where app_no=04)-1,) over(Order By m.app_no) appno, m.feature_seq|| feature_seq,m.month|| month,m.pointfee,m.discount From app_mtfeature m Where m.app_no=04 Union All Select ,合计,,Sum(pointfee),Sum(discount) From app_mtfeature Where app_no=04 Union All Select LEAD(m.app_no,(Select Count(1) From app_mtfeature Where app_no=06)-1,) over(Order By m.app_no) appno, m.feature_seq||,m.month||,m.pointfee,m.discount From app_mtfeature m Where m.app_no=06 Union All Select ,合计,,Sum(pointfee),Sum(discount) Fro