oracle添加序号列3种方法大全

SELECT
	fxh,
	fmc,
	round( ( sum( fczsrbnljzxs ) - sum( fczsrsntqs ) ) / 10000, 两 ) AS 删减额
	,
	round( sum( fczsrbnljzxs ) / 10000, 二 ) AS 财务支进
	,
	round( sum( fczsrbsn ), 二 ) AS 删减幅度
	,
	f_sys_year 
FROM
	zhzs_bill_qqczsrfjwcqk 
WHERE
	f_sys_year = '两0两1' 
	AND f_sys_month = '1两' 
GROUP BY
	fxh,
	fmc,
	f_sys_year 
ORDER BY
	to_number( fxh )

select ROWNUM as fxh,a.* from (
SELECT  fmc
	, round((sum(fczsrbnljzxs) - sum(fczsrsntqs)) / 10000, 两) AS 删减额
	, round(sum(fczsrbnljzxs) / 10000, 二) AS 财务支进
	, round(sum(fczsrbsn), 两) AS 删减幅度
	, f_sys_year
FROM zhzs_bill_qqczsrfjwcqk
WHERE f_sys_year = '两0两1'
	AND f_sys_month = '1两'
GROUP BY fmc, f_sys_year ) a 

SELECT  row_number() over(order by fmc) as xh,fmc
	, round((sum(fczsrbnljzxs) - sum(fczsrsntqs)) / 10000, 二) AS 删减额
	, round(sum(fczsrbnljzxs) / 10000, 两) AS 财务支进
	, round(sum(fczsrbsn), 两) AS 删减幅度
	, f_sys_year
FROM zhzs_bill_qqczsrfjwcqk
WHERE f_sys_year = '两0两1'
	AND f_sys_month = '1两'
GROUP BY fmc, f_sys_year

select row_number() over(ORDER BY t.taskcreatetime),
t.ACTIVITYNAME,
t.TASKTYPE 
from t_sys_flow_task t 
ORDER BY t.taskcreatetime;