Help Center/ SecMaster/ User Guide/ Threat Operations/ Query and Analysis Syntax - V1/ Analysis Statements/ ORDER BY
Updated on 2024-11-11 GMT+08:00
View PDF
Share

ORDER BY

The syntax of a complete analysis statement is as follows:

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

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

age

28

32

32

36
Parent topic: Analysis Statements