LIMIT

LIMIT caps how many rows the report returns. It is most useful with ORDER BY, which decides which rows survive the cap.

FROM sales
  SHOW total_revenue
  GROUP BY vendor
  ORDER BY total_revenue DESC
  LIMIT 10

This keeps the ten vendors with the highest revenue. Without an ORDER BY, the rows kept are not meaningfully ranked. LIMIT caps the rows in the results table. To cap how many categories a chart plots instead, use the ITEMS option on VISUALIZE.

Introduction

Syntax

Datasets

Examples