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;