tencent cloud

Cloud Log Service

DokumentasiCloud Log ServiceOperation GuideSearch and Analysis (Log Topic)Statistical Analysis (SQL)SQL SyntaxLIMIT Syntax

LIMIT Syntax

Download
Mode fokus
Ukuran font
Terakhir diperbarui: 2026-05-14 21:12:59
The LIMIT syntax is used to limit the number of rows in the output result.

Syntax Format

Read the first N rows:
limit N
Read N rows starting from row S:
offset S limit N

Syntax Example

Get the first 10 rows of results:
* | select status, count(*) as pv group by status limit 10
Get the results for rows 3 to 42 (40 rows in total):
* | select status, count(*) as pv group by status offset 2 limit 40

Restriction

Metric
Restriction
Remarks
Number of SQL results
Each SQL returns up to 10,000 results.
Default: 100; Maximum: 10,000

Topik sebelumnya: GROUP BY SyntaxTopik selanjutnya: ORDER BY Syntax

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan