Vex · Query DSL

Limit: default and maximum

limit sets the maximum number of rows a query returns. A query without limit compiles with the default of 100, and a limit above 1,000 is clamped to 1,000. Both numbers are engine settings: defaultLimit and maxLimit.

Queries

[
  { from: ['shows'], fields: ['shows.night'] },
  { from: ['shows'], fields: ['shows.night'], limit: 3 },
  { from: ['shows'], fields: ['shows.night'], limit: 5000 },
]

SQL, one line per query

SELECT s1.night AS "night" FROM shows AS s1 LIMIT 100
SELECT s1.night AS "night" FROM shows AS s1 LIMIT 3
SELECT s1.night AS "night" FROM shows AS s1 LIMIT 1000

Output matches the expected value

Runs in this page on the installed package. The input and the expected output are defined by the example.