ORDER BY

ORDER BY sorts the results. Name a column and a direction: DESC for largest first, or ASC for smallest first.

FROM sales
  SHOW total_revenue, units_sold
  GROUP BY vendor
  ORDER BY total_revenue DESC

You can sort by more than one column. Later keys break ties in the earlier ones.

FROM sales
  SHOW total_revenue, units_sold
  GROUP BY vendor
  ORDER BY total_revenue DESC, units_sold ASC

Sorting is what makes LIMIT meaningful, since it decides which rows the cap keeps. It also sets the order that WITH CUMULATIVE_VALUES accumulates over.

Introduction

Syntax

Datasets

Examples