On this page
Kater SQL Functions Totals
Totals
A total adds up a column over every row of the query, and a row total adds up columns on each row, as a table's Total row and Total column write them.
The warehouse works each one out. A total counts every row that HAVING, QUALIFY and LIMIT would take out, so a query with a total has none of them. See Charts.
| Function | What it does |
|---|---|
KATER__TOTAL | The total of the value over every row of the query, or over the rows of each group its PARTITION BY names. |
KATER__ROW_TOTAL | The value and the other fields added up on each row, as a spreadsheet’s row total. |