Updated on 2024-07-18 GMT+08:00

Analysis Statements - LIMIT

Specifies the number of returned data records.

Specifying the Number of Returned Records

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

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