Updated on 2022-09-29 GMT+08:00

OrderBy & Limit

OrderBy

Function

This clause is used to sort data in ascending order on a time attribute.

Precautions

Currently, only sorting by time attribute is supported.

Example

Sort data in ascending order on the time attribute.

SELECT *
FROM Orders
ORDER BY orderTime;

Limit

Function

This clause is used to constrain the number of rows returned.

Precautions

This clause is used in conjunction with ORDER BY to ensure that the results are deterministic.

Example

SELECT *
FROM Orders
ORDER BY orderTime
LIMIT 3;