[
https://issues.apache.org/jira/browse/DERBY-4518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12805068#action_12805068
]
Dag H. Wanvik commented on DERBY-4518:
--------------------------------------
The right order would be:
Derby processes a SelectExpression in the following order:
* FROM clause
* WHERE clause
* GROUP BY (or implicit GROUP BY)
* HAVING clause
* ORDER BY clause
* result offset clause
* fetch first clause
* SELECT clause
> Document ORDER BY and OFFSET/FETCH in subqueries
> ------------------------------------------------
>
> Key: DERBY-4518
> URL: https://issues.apache.org/jira/browse/DERBY-4518
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Reporter: Dag H. Wanvik
> Assignee: Kim Haase
> Attachments: DERBY-4518.diff, DERBY-4518.stat, DERBY-4518.zip
>
>
> DERBY-4397 and DERBY-4398 extends the usability of ORDER BY and OFFSET/FETCH
> to subqueries and view. This should be documented.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
