ASSUME ORDER BY
Checking that the SELECT
result is sorted by the value in the specified column or multiple columns. The result of such a SELECT
statement is treated as sorted, but without actually running a sort. Sort check is performed at the query execution stage.
As in case of ORDER BY
, it supports setting the sort order using the keywords ASC
(ascending order) and DESC
(descending order). Expressions are not supported in ASSUME ORDER BY
.
Examples
SELECT key || "suffix" as key, -CAST(subkey as Int32) as subkey
FROM my_table
ASSUME ORDER BY key, subkey DESC;