over partition by

Used to show sum of a column:

Example:

select COL1, COL2, sum(COL2) over (partition by (COL1)) as TOTAL from TEST_TABLE