BigQuery calculate grand totals row

Question

Is there any way to add row with grand totals under my result set, like ms-sql ROLLUP operator? I want to avoid using extra query for this totals.

Answer 1

Edited: BigQuery now supports the ROLLUP operator. See the query reference docs for more information.

Answer 2

Update: Since this question was posted, BigQuery did implement support GROUP BY ROLLUP clause compatible with SQL Standard. It is documented here: https://cloud.google.com/bigquery/query-reference#groupby