GROUP BY

GROUP BY collapses your rows into groups and aggregates each metric within them. List one or more dimensions, separated by commas, and every metric in SHOW is totalled per group.

FROM sales
  SHOW total_revenue, units_sold
  GROUP BY vendor

Grouping by two dimensions gives you a breakdown within a breakdown, such as product type within vendor.

FROM sales
  SHOW total_revenue
  GROUP BY vendor, product_type

Top N per dimension

Prefix a dimension with ONLY TOP <n> to keep just its highest-ranking values. This is handy on a two-dimension breakdown where you want, say, the top five vendors but every product type within them.

FROM sales
  SHOW total_revenue
  GROUP BY ONLY TOP 5 vendor, product_type

Which dimensions are available depends on the dataset. To filter groups by their totals after aggregating, use HAVING. To sort the grouped results, use ORDER BY.

Introduction

Syntax

Datasets

Examples

Top N per dimension

​Top N per dimension

Top N per dimension