Allow ORDER BY in subqueries

Details

Description

SQL 2008 allows ORDER BY to be specified in subqueries. In conjunction with OFFSET/FETCH and/or ROW_NUMBER
meaningful subqueries with row ordering may be formulated. Cf. MySQL's LIMIT may be used in subqueries as well.
Note that OFFSET/FETCH is currently not allowed in subqueries, either.