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


Updated 6 months ago