This documentation is for an out-of-date version of Apache Flink. We recommend you use the latest stable version.

LIMIT clause #

Batch

LIMIT clause constrains the number of rows returned by the SELECT statement. In general, this clause is used in conjunction with ORDER BY to ensure that the results are deterministic.

The following example selects the first 3 rows in Orders table.

SELECT *
FROM Orders
ORDER BY orderTime
LIMIT 3