LIMIT Clause

The LIMIT clause restricts the number of rows in the result set. LIMIT ALL is not supported, and you must specify an integer value count when you specify LIMIT. When used with the ORDER BY syntax, you must specify a LIMIT clause with a value of 1,000 or less.

The SQL Editor imposes a default LIMIT 1000 if you do not otherwise specify one. In the SQL Editor, the lowest value specified by the query or the UI setting is used.

LIMIT count 

Example

SELECT _id,
       o_orderkey,
       o_custkey,
       o_orderstatus,
       o_totalprice
FROM chaos."orders-view" where o_totalprice > 200000 order by o_totalprice
LIMIT 5