tencent cloud

Cloud Log Service

문서Cloud Log ServiceOperation GuideSearch and Analysis (Log Topic)Statistical Analysis (SQL)SQL SyntaxLIMIT Syntax

LIMIT Syntax

다운로드
포커스 모드
폰트 크기
마지막 업데이트 시간: 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

이전 주제: GROUP BY Syntax다음 주제: ORDER BY Syntax

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백