tencent cloud

Cloud Log Service

DocumentationCloud Log ServiceOperation GuideSearch and Analysis (Log Topic)Statistical Analysis (SQL)SQL SyntaxORDER BY Syntax

ORDER BY Syntax

Download
Focus Mode
Font Size
Last updated: 2026-05-21 19:51:20
AI-Translated
The ORDER BY syntax is used to sort analysis results by a specified column name.

Syntax Format

ORDER BY column name [DESC | ASC]
Note:
You can specify multiple column names to sort analysis results in different sorting modes, for example, ORDER BY column name 1[DESC | ASC], column name 2[DESC | ASC].
If you do not specify the keyword DESC or ASC, the system sorts the analysis results in ascending order.
If the target column for sorting contains duplicated values, the sorting result may be different each time. If you want the sorting result to remain the same in each sorting, you can specify multiple columns for sorting.
Parameter descriptions:
Parameter
Description
Column name
The column name refers to a log field name or an aggregate function calculation result column.
DESC
Sort data in descending order.
ASC
Sort data in ascending order.

Syntax Example

Count the number of requests in different states and sort them in descending order by the number of requests:
* | 
SELECT 
  status, 
  count(*) AS pv 
GROUP BY 
  status 
ORDER BY 
  pv DESC
Calculate the average request time for each server and sort them in ascending order:
* | 
SELECT 
  remote_addr, 
  avg(request_time) AS request_time 
GROUP BY 
  remote_addr 
ORDER BY 
  request_time ASC 
LIMIT 
  10

Previous Topic: LIMIT SyntaxNext Topic: SELECT Syntax

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback