BigQuery computes a great summary string

Question

Is there a way to add a row with totals in my result set, e.g. ms-sql ROLLUP? I want to avoid using an extra query for these totals.

+4

Kirill Solokhov Mar 12 '14 at 15:59

2 answers

Update . Since this question was submitted, BigQuery implemented a support offer GROUP BY ROLLUPthat is compliant with the SQL standard. This is described here: https://cloud.google.com/bigquery/query-reference#groupby

+3

Mosha pasumansky Apr 17 '15 at 4:25

Jordan Tigani · Accepted Answer · 2014-03-12T16:52:16+0000

Edited: BigQuery now supports the ROLLUP statement. See the docs request link for more information .