order

order by, keyword

order by is a tile option that controls row ordering in show table.

Examples

table T = with
  [| as Id, as X |]
  [| "a", 3 |]
  [| "b", 1 |]
  [| "c", 4 |]

show table "Ordered" with
  T.Id
  T.X
  order by T.X

This produces the following table (ordered by X ascending):

Remarks

order by is applied after tile-level aggregation. Use desc to reverse the ordering, and use tuple syntax for multi-column ordering.