Reference Guide
>
TDV Query Engine Options
>
SELECT Options
>
DISABLE_SORT_REMOVAL (SELECT Option)
DISABLE_SORT_REMOVAL (SELECT Option)
DISABLE_SORT_REMOVAL causes the SELECT to retain the ORDER BY clause in the sub-query.
Operator
SELECT
Syntax
disable_sort_removal
Example
SELECT {OPTION
DISABLE_SORT_REMOVAL
}