tps/database/reports/hunt_bal.sql

9 lines
157 B
MySQL
Raw Permalink Normal View History

2024-08-28 12:42:56 -04:00
\timing
SELECT
r.*
,SUM(r."Amount") OVER (ORDER BY r."Date" asc , r.id) + 29909.75 balance
FROM
2024-08-29 13:34:50 -04:00
tpsv.hunt_mapped r
2024-08-28 12:42:56 -04:00
ORDER BY
r."Date" desc