ORDER BY Clause in Confluent Cloud for Apache Flink

Confluent Cloud for Apache Flink® enables sorting rows from a SELECT statement.

Description

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 sort orders can be freely chosen.

When running in batch mode, there is no sort-order limitation.

Example

SELECT *
FROM orders
ORDER BY order_time, order_id