Limit Clause#

The Limit clause is used to limit the number of results. Limit accept a non-negative integral followed as limit count, 0 produce empty set.

Syntax#

LimitClause
         ::= 'LIMIT' int_leteral

SQL Statement Template#

SELECT ... LIMIT ...

Description#

Limit clause is not supported in online request mode. By practice, limit clause should be used together with order by clause, to constrains the result rows into a unique order. OpenMLDB does not support order by clause yet; without it it may get inconsistent results for the same query.

SELECT Statement Elements

Offline Mode

Online Preview Mode

Online Request Mode

Note

LIMIT Clause

✓

✓

x

The Limit clause is used to limit the number of results. OpenMLDB currently only supports one parameter to limit the maximum number of rows of returned data.

Example#

SELECT with LIMIT#

  SELECT t1.COL1 c1 FROM t1 limit 10;