Help Center/ SecMaster/ User Guide/ Log Audit/ Query and Analysis Syntax/ Analysis Statements/ ORDER BY
Updated on 2025-09-24 GMT+08:00
View PDF

ORDER BY

The syntax of a complete analysis statement is as follows:

1
2
3
4
 
SELECT [DISTINCT] (* | expression) [AS alias] [, ...]
[GROUP BY expression [, ...] [HAVING predicates]]
[ORDER BY expression [ASC | DESC] [, ...]]
[LIMIT size OFFSET offset]

Where, ORDER BY indicates sorting by field value. The following part describes parameters and examples for the ORDER BY syntax.

Sorting Data by Field Value

1
 
SELECT age ORDER BY age DESC
Table 1 Sorting by field value

age

28

32

32

36
Parent topic: Analysis Statements