groupby的用法

需求是让两行数据相加

sql

WITH b AS (
	SELECT
		e.CREATE_TIME,
		nvl( e.RECHARGE_COUNT, 0 ) RECHARGE_COUNT,
		nvl( e.RECHARGE_MONEY, 0 ) RECHARGE_MONEY,
		nvl( e.HANDLE_COUNT, 0 ) HANDLE_COUNT,
		nvl( e.HANDLE_MONEY, 0 ) HANDLE_MONEY,
		nvl( e.INCOME_COUNT, 0 ) INCOME_COUNT,
		nvl( e.INCOME_MONEY, 0 ) INCOME_MONEY,
		nvl( e.BESTPAYCHECK_COUNT, 0 ) BESTPAYCHECK_COUNT,
		nvl( e.BESTPAYCHECK_MONEY, 0 ) BESTPAYCHECK_MONEY,
		nvl( e.EGROUPCHECK_COUNT, 0 ) EGROUPCHECK_COUNT,
		nvl( e.EGROUPCHECK_MONEY, 0 ) EGROUPCHECK_MONEY,
		nvl( e.WANWEICHECK_COUNT, 0 ) WANWEICHECK_COUNT,
		nvl( e.WANWEICHECK_MONEY, 0 ) WANWEICHECK_MONEY,
		nvl( e.BEGIN_BALANCE, 0 ) BEGIN_BALANCE,
		nvl( e.LAST_BALANCE, 0 ) LAST_BALANCE,
		nvl( e.USABLE_ACCOUNT, 0 ) USABLE_ACCOUNT,
		nvl( e.INCOME_TOTAL, 0 ) INCOME_TOTAL,
		nvl( e.CRM_FOCUS, 0 ) CRM_FOCUS,
		nvl( e.CRM_DIRECT, 0 ) CRM_DIRECT,
		nvl( e.BSN_CASH, 0 ) BSN_CASH,
		nvl( e.PAIDIN_TOTAL, 0 ) PAIDIN_TOTAL,
		nvl( e.BALANCE_RESULT, 0 ) BALANCE_RESULT 
	FROM
		EWT_BALANCE e 
	),
	b1 AS (
	SELECT
		b.CREATE_TIME,
		sum( b.RECHARGE_COUNT ) RECHARGE_COUNT,
		sum( b.RECHARGE_MONEY ) RECHARGE_MONEY,
		sum( b.HANDLE_COUNT ) HANDLE_COUNT,
		sum( b.HANDLE_MONEY ) HANDLE_MONEY,
		sum( b.INCOME_COUNT ) INCOME_COUNT,
		sum( b.INCOME_MONEY ) INCOME_MONEY,
		sum( b.BESTPAYCHECK_COUNT ) BESTPAYCHECK_COUNT,
		sum( b.BESTPAYCHECK_MONEY ) BESTPAYCHECK_MONEY,
		sum( b.EGROUPCHECK_COUNT ) EGROUPCHECK_COUNT,
		sum( b.EGROUPCHECK_MONEY ) EGROUPCHECK_MONEY,
		sum( b.WANWEICHECK_COUNT ) WANWEICHECK_COUNT,
		sum( b.WANWEICHECK_MONEY ) WANWEICHECK_MONEY,
		sum( b.BEGIN_BALANCE ) BEGIN_BALANCE,
		sum( b.LAST_BALANCE ) LAST_BALANCE,
		sum( b.USABLE_ACCOUNT ) USABLE_ACCOUNT,
		sum( b.INCOME_TOTAL ) INCOME_TOTAL,
		sum( b.CRM_FOCUS ) CRM_FOCUS,
		sum( b.CRM_DIRECT ) CRM_DIRECT,
		sum( b.BSN_CASH ) BSN_CASH,
		sum( b.PAIDIN_TOTAL ) PAIDIN_TOTAL,
		sum( b.BALANCE_RESULT ) BALANCE_RESULT 
	FROM
		b 
	GROUP BY
		b.CREATE_TIME 
	) SELECT
	* 
FROM
	b1 
ORDER BY
	CREATE_TIME ASC