You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Dag H. Wanvik (JIRA)" <ji...@apache.org> on 2013/01/03 06:52:12 UTC
[jira] [Commented] (DERBY-6014) Document ORDER BY and FETCH/OFFSET
in set operands
[ https://issues.apache.org/jira/browse/DERBY-6014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13542732#comment-13542732 ]
Dag H. Wanvik commented on DERBY-6014:
--------------------------------------
It looks like this can be skipped as our current docs indicate that this is already alllowed, cf. this section in the reference manual:
(https://builds.apache.org/job/Derby-docs/lastSuccessfulBuild/artifact/trunk/out/ref/rrefsqlj21571.html)
query:
{
( Query
[ ORDER BY clause ]
[ result offset clause ]
[ fetch first clause ]
) |
Query INTERSECT [ ALL | DISTINCT ] Query |
Query EXCEPT [ ALL | DISTINCT ] Query |
Query UNION [ ALL | DISTINCT ] Query |
SelectExpression | VALUES Expression
}
Notice the clauses on the query inside the parentheses.
> Document ORDER BY and FETCH/OFFSET in set operands
> --------------------------------------------------
>
> Key: DERBY-6014
> URL: https://issues.apache.org/jira/browse/DERBY-6014
> Project: Derby
> Issue Type: Sub-task
> Components: Documentation
> Reporter: Dag H. Wanvik
>
> The new functionality should be documented.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira