Help Center/ SecMaster/ User Guide (Kuala Lumpur Region)/ Threat Operations/ Security Analysis/ Query and Analysis Statements - SQL Syntax/ Analysis Statements - ORDER BY
Updated on 2024-10-29 GMT+08:00
View PDF
Share

Analysis Statements - 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