1 ORDER BY clause 

Batch Streaming

The ORDER BY clause causes the result rows to be sorted according to the specified expression(s). If two rows are equal according to the leftmost expression, they are compared according to the next expression and so on. If they are equal according to all specified expressions, they are returned in an implementation-dependent order.

When running in streaming mode, the primary sort order of a table must be ascending on a time attribute. All subsequent orders can be freely chosen. But there is no this limitation in batch mode.

SELECT *
FROM Orders
ORDER BY order_time, order_id

2 LIMIT clause

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

Flink基础（130）：FLINK-SQL语法 (24) DQL(16) OPERATIONS(13)ORDER BY clause/LIMIT clause