[Oracle] Oracle實現column累加

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
select [fields],sum(field) over (order by [fields] rows between unbounded preceding and current row) from table;
select [fields],sum(field) over (order by [fields] rows between unbounded preceding and current row) from table;
select [fields],sum(field) over (order by [fields] rows between unbounded preceding and current row) from table;

rows between 可選 preceding, following, current row限制sum條件