LIMIT Syntax¶
LIMIT works the same as in SQL, and must be used with pipe |. The LIMIT clause accepts one or two arguments. The values of both arguments must be zero or positive integers.
ORDER BY <expressions> [ASC | DESC]
LIMIT [<offset_value>,] <number_rows>
- expressions
The columns or calculations that you wish to sort.
- number_rows
It constrains the number of rows to return. For example, LIMIT 10 would return the first 10 rows. This is where sorting order matters so be sure to use an
ORDER BYclause appropriately.
- offset_value
Optional. It defines from which row to start including the rows in the output. The offset starts from zero.
When using
LIMIT, it is important to use anORDER BYclause that constrains the output into a unique order. Otherwise, you will get an unpredictable subset of the output.
For example:
nebula> GO FROM 200 OVER serve REVERSELY YIELD $$.player.name AS Friend, $$.player.age AS Age | ORDER BY Age, Friend | LIMIT 3;
=========================
| Friend | Age |
=========================
| Kyle Anderson | 25 |
-------------------------
| Aron Baynes | 32 |
-------------------------
| Marco Belinelli | 32 |