[ 
https://issues.apache.org/jira/browse/DERBY-4518?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12803537#action_12803537
 ] 

Dag H. Wanvik commented on DERBY-4518:
--------------------------------------

The last statement's syntax is wrong: it should be:
  values (3,21),(1,22),(2,23) order by 1 offset 2 rows;

Thats is, the "rows" keyword is needed. 


> 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
>
> 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.

Reply via email to