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.
Attachments
Attachments
Issue Links
- is related to
-
DERBY-6006 NullPointerException in INSERT INTO ... SELECT FROM ... ORDER BY
- Closed
- relates to
-
DERBY-4649 Make optimizer utilize any useful information in OFFSET/FETCH NEXT in subqueries
- Open
-
DERBY-4398 Allow OFFSET/FETCH in subqueries
- Closed
-
DERBY-4518 Document ORDER BY and OFFSET/FETCH in subqueries
- Closed
-
DERBY-4 "order by" is not supported for "insert ... select"
- Closed