LIMIT

Syntax of Analysis Statements

The syntax of a complete analysis statement is as follows:

     SELECT [DISTINCT] (* | expression) [AS alias] [, ...]
[GROUP BY expression [, ...] [HAVING predicates]]
[ORDER BY expression [ASC | DESC] [, ...]]
[LIMIT size OFFSET offset]

Where, LIMIT indicates the number of returned data records. The following part describes parameters and examples for the LIMIT syntax.

Specifying the Number of Returned Records

Query and display the first log.

     *|SELECT * LIMIT 1

**Table 1** Specifying the number of returned records
account_number	firstname	gender	city	balance	employer	state	lastname	age
1	Amber	M	Brogan	39225	Pyrami	IL	Duke	32

Specifying the Number of Returned Records and Offsets

Query and display the second log.

     *|SELECT * LIMIT 1 OFFSET 1

**Table 2** Specifying the number of returned records and offsets
account_number	firstname	gender	city	balance	employer	state	lastname	age
16	Hattie	M	Dante	5686	Netagy	TN	Bond	36

Parent topic: Analysis Statements

Previous topic: ORDER BY

Next topic: Functions

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

For any further questions, feel free to contact us through the chatbot.

Chatbot