sql记录

SELECT
	A .desc_,
	NVL (b.fee_all, 0) fee_all,
	NVL (b.fee1, 0) fee1,
	NVL (b.fee2, 0) fee2,
	NVL (b.fee3, 0) fee3,
	NVL (b.fee4, 0) fee4,
	NVL (b.fee5, 0) fee5,
	NVL (b.fee6, 0) fee6,
	NVL (b.fee7, 0) fee7,
	NVL (b.fee8, 0) fee8,
	NVL (b.fee9, 0) fee9,
	NVL (b.fee10, 0) fee10,
	NVL (b.fee11, 0) fee11
FROM
	(
		SELECT
			*
		FROM
			bdf2_dept D
		WHERE
			D .parent_id_ = '00'
		AND D .level_ = 1
	) A
LEFT JOIN (
	SELECT
		f.dept_id,
		f.month_fee fee_all,
		SUM (DECODE(D .proj, 0, D .fee, 0)) fee1,
		SUM (DECODE(D .proj, 1, D .fee, 0)) fee2,
		SUM (DECODE(D .proj, 2, D .fee, 0)) fee3,
		SUM (DECODE(D .proj, 3, D .fee, 0)) fee4,
		SUM (DECODE(D .proj, 4, D .fee, 0)) fee5,
		SUM (DECODE(D .proj, 5, D .fee, 0)) fee6,
		SUM (DECODE(D .proj, 6, D .fee, 0)) fee7,
		SUM (DECODE(D .proj, 7, D .fee, 0)) fee8,
		SUM (DECODE(D .proj, 8, D .fee, 0)) fee9,
		SUM (DECODE(D .proj, 9, D .fee, 0)) fee10,
		SUM (DECODE(D .proj, 10, D .fee, 0)) fee11
	FROM
		saf_t_fee f,
		saf_t_fee_detail D
	WHERE
		f.fee_id = D .fee_id
	AND f.del_flag = '0'
	AND D .del_flag = '0'
	AND f.report_month = '2018-10'
	GROUP BY
		f.dept_id,
		f.month_fee
) b ON A .id_ = b.dept_id
UNION ALL
	SELECT
		'合计' AS desc_,
		SUM (fee_all) AS fee_all,
		SUM (fee1) fee1,
		SUM (fee2) fee2,
		SUM (fee3) fee3,
		SUM (fee4) fee4,
		SUM (fee5) fee5,
		SUM (fee6) fee6,
		SUM (fee7) fee7,
		SUM (fee8) fee8,
		SUM (fee9) fee9,
		SUM (fee10) fee10,
		SUM (fee11) fee11
	FROM
		(
			SELECT
				A .desc_,
				NVL (b.fee_all, 0) fee_all,
				NVL (b.fee1, 0) fee1,
				NVL (b.fee2, 0) fee2,
				NVL (b.fee3, 0) fee3,
				NVL (b.fee4, 0) fee4,
				NVL (b.fee5, 0) fee5,
				NVL (b.fee6, 0) fee6,
				NVL (b.fee7, 0) fee7,
				NVL (b.fee8, 0) fee8,
				NVL (b.fee9, 0) fee9,
				NVL (b.fee10, 0) fee10,
				NVL (b.fee11, 0) fee11
			FROM
				(
					SELECT
						*
					FROM
						bdf2_dept D
					WHERE
						D .parent_id_ = '00'
					AND D .level_ = 1
				) A
			LEFT JOIN (
				SELECT
					f.dept_id,
					f.month_fee fee_all,
					SUM (DECODE(D .proj, 0, D .fee, 0)) fee1,
					SUM (DECODE(D .proj, 1, D .fee, 0)) fee2,
					SUM (DECODE(D .proj, 2, D .fee, 0)) fee3,
					SUM (DECODE(D .proj, 3, D .fee, 0)) fee4,
					SUM (DECODE(D .proj, 4, D .fee, 0)) fee5,
					SUM (DECODE(D .proj, 5, D .fee, 0)) fee6,
					SUM (DECODE(D .proj, 6, D .fee, 0)) fee7,
					SUM (DECODE(D .proj, 7, D .fee, 0)) fee8,
					SUM (DECODE(D .proj, 8, D .fee, 0)) fee9,
					SUM (DECODE(D .proj, 9, D .fee, 0)) fee10,
					SUM (DECODE(D .proj, 10, D .fee, 0)) fee11
				FROM
					saf_t_fee f,
					saf_t_fee_detail D
				WHERE
					f.fee_id = D .fee_id
				AND f.del_flag = '0'
				AND D .del_flag = '0'
				AND f.report_month = '2018-10'
				GROUP BY
					f.dept_id,
					f.month_fee
			) b ON A .id_ = b.dept_id
		) G