Cloud Log Service
- Release Notes and Announcements
- Announcements
- Product Introduction
- Limits
- Log Collection
- Purchase Guide
- Pay-as-You-Go
- Getting Started
- Operation Guide
- Resource Management
- Permission Management
- Log Collection
- Collection by LogListener
- LogListener Installation and Deployment
- Collecting Text Log
- Collecting Logs in Self-Built Kubernetes Cluster
- Importing Data
- Metric Collection
- Log Storage
- Search and Analysis (Log Topic)
- Statistical Analysis (SQL)
- SQL Syntax
- SQL Functions
- Search and Analysis (Metric Topic)
- Dashboard
- Creating Statistical Charts
- Data Processing documents
- Data Processing
- Data Processing Functions
- Scheduled SQL Analysis
- Shipping and Consumption
- Shipping to COS
- Shipping to CKafka
- Shipping to ES
- Log Shipping
- Consumption over Kafka
- Monitoring Alarm
- Managing Alarm Policies
- Channels to Receive Alarm Notifications
- Cloud Insight
- Historical Documentation
- Practical Tutorial
- Search and Analysis
- Monitoring Alarm
- Shipping and Consumption
- Developer Guide
- API Documentation
- Making API Requests
- Topic Management APIs
- Log Set Management APIs
- Topic Partition APIs
- Machine Group APIs
- Collection Configuration APIs
- Log APIs
- Metric APIs
- Alarm Policy APIs
- Data Processing APIs
- Kafka Protocol Consumption APIs
- CKafka Shipping Task APIs
- Kafka Data Subscription APIs
- COS Shipping Task APIs
- SCF Delivery Task APIs
- Scheduled SQL Analysis APIs
- COS Data Import Task APIs
- FAQs
- Health Check
- Collection
- Log Search
DocumentationCloud Log ServiceOperation GuideSearch and Analysis (Log Topic)Statistical Analysis (SQL)SQL SyntaxORDER BY Syntax
ORDER BY Syntax
Last updated: 2024-01-20 17:25:15
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 | Group data by log field name or 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
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No