语法
SELECT
ROW_NUMBER() OVER(ORDER BY sta.ID_) feenum,
aa,
bb
FROM
sta
SELECT
row_number() over (order by J.ID_) feenum,
desc_,
month_cost,
month_tax,
month_fee,
year_cost,
year_tax,
year_fee
FROM
(
SELECT
A .desc_,
A .ID_,
NVL (b.month_cost, 0) month_cost,
NVL (b.month_tax, 0) month_tax,
NVL (b.month_fee, 0) month_fee,
NVL (b.year_cost, 0) year_cost,
NVL (b.year_tax, 0) year_tax,
NVL (b.year_fee, 0) year_fee
FROM
(
SELECT
*
FROM
bdf2_dept D
WHERE
D .parent_id_ = '00'
AND D .level_ = '1'
) A
LEFT JOIN (
SELECT
*
FROM
saf_t_fee f
WHERE
f.del_flag = '0'
) b ON A .id_ = b.dept_id
AND b.report_date >= TO_DATE ('2018-12-01', 'yyyy-MM-dd')
AND b.report_date <= TO_DATE ('2018-12-31', 'yyyy-MM-dd')
UNION ALL
SELECT
'合计' desc_,
'a' ID_,
SUM (month_cost) month_cost,
SUM (month_tax) month_tax,
SUM (month_fee) month_fee,
SUM (year_cost) year_cost,
SUM (year_tax) year_tax,
SUM (year_fee) year_fee
FROM
(
SELECT
A .desc_,
NVL (b.month_cost, 0) month_cost,
NVL (b.month_tax, 0) month_tax,
NVL (b.month_fee, 0) month_fee,
NVL (b.year_cost, 0) year_cost,
NVL (b.year_tax, 0) year_tax,
NVL (b.year_fee, 0) year_fee
FROM
(
SELECT
*
FROM
bdf2_dept D
WHERE
D .parent_id_ = '00'
AND D .level_ = '1'
) A
LEFT JOIN (
SELECT
*
FROM
saf_t_fee f
WHERE
f.del_flag = '0'
) b ON A .id_ = b.dept_id
AND b.report_date >= TO_DATE ('2018-12-01', 'yyyy-MM-dd')
AND b.report_date <= TO_DATE ('2018-12-31', 'yyyy-MM-dd')
)
) J
ORDER BY
J.ID_