Updated on 2023-11-03 GMT+08:00

SORT BY

Function

This statement is used to achieve the partial sorting of tables according to fields.

Syntax

1
2
3
SELECT attr_expr_list FROM table_reference
  SORT BY col_name
  [ASC | DESC] [,col_name [ASC | DESC],...];

Keyword

  • ASC/DESC: ASC sorts from the lowest value to the highest value. DESC sorts from the highest value to the lowest value. ASC is the default sort order.
  • SORT BY: Used together with GROUP BY to perform local sorting of a single column or multiple columns for PARTITION.

Precautions

The to-be-sorted table must exist. If this statement is used to sort a table that does not exist, an error is reported.

Example

To sort the student table in ascending order of the score field in Reducer, run the following statement:

1
2
SELECT * FROM student
  SORT BY score;