CODE EXAMPLE FOR SQL

sum over partition by postgresql

SELECT salary, sum(salary) OVER () FROM empsalary;