LIMIT Clause

Cap the number of results returned by a SELECT.

The LIMIT clause restricts the number of rows in the result set. LIMIT ALL is not supported. In the ChaosSearch SQL implementation, ORDER BY queries require a numeric LIMIT clause.

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
3056 3148