tencent cloud


LIMIT Syntax

Last updated: 2022-04-18 15:19:46

    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


    Number of SQL resultsEach SQL returns up to 10,000 results.Default: 100; Maximum: 10,000
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support