tencent cloud

PrevNext

masukan

cari berdasarkan kata kunci

Recent Pages

Dokumentasi
Cloud Log Service
    Dokumentasi
    Download PDF

    ORDER BY Syntax

    Terakhir diperbarui:2024-01-20 17:25:15
    Unduh PDF
      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
      
      Hubungi Kami

      Hubungi tim penjualan atau penasihat bisnis kami untuk membantu bisnis Anda.

      Hubungi Kami
      Dukungan Teknis

      Buka tiket jika Anda mencari bantuan lebih lanjut. Tiket kami tersedia 7x24.

      Kirim Tiket
      Dukungan Telepon 7x24
      Copyright © 2013-2024 Tencent Cloud. All Rights Reserved.
      Kebijakan PrivasiLegalKebijakan Cookie