ogiovannyoliveira/accumulative.sql

Last active April 9, 2020 14:10

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/ogiovannyoliveira/6a945ced811f6b15e688d6a2cbc8ea36.js"></script>
Save ogiovannyoliveira/6a945ced811f6b15e688d6a2cbc8ea36 to your computer and use it in GitHub Desktop.

Download ZIP

Consulta SQL com valor acumulativo.

Raw

accumulative.sql

	SELECT
	sum(sum(column)) OVER (ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as accumulated
	FROM
	table
	WHERE id_foo = ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment