db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-4192) OFFSET and FETCH FIRST documentation improvement
Date Wed, 29 Apr 2009 20:39:30 GMT

     [ https://issues.apache.org/jira/browse/DERBY-4192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Kim Haase updated DERBY-4192:
-----------------------------

    Attachment: derby-4192-2.patch
                rrefsqljoffsetfetch.html

Good work, Tiago! Thank you for taking this on. I'm attaching a suggested revised patch, derby-4192-2.patch,
with some formatting and wording changes to conform to more usual technical writing usage.
If they change the meaning, though, please fix them back again!

The output HTML is in rrefsqljoffsetfetch.html.

> OFFSET and FETCH FIRST documentation improvement
> ------------------------------------------------
>
>                 Key: DERBY-4192
>                 URL: https://issues.apache.org/jira/browse/DERBY-4192
>             Project: Derby
>          Issue Type: Improvement
>    Affects Versions: 10.5.1.1
>            Reporter: Tiago R. Espinha
>            Assignee: Tiago R. Espinha
>            Priority: Minor
>         Attachments: derby-4192-2.patch, derby-4192.patch, derby-4192.patch, refderby.pdf,
rrefsqljoffsetfetch.html
>
>
> I have a suggestion regarding the documentation for the OFFSET and FETCH FIRST documentation.
On these documents, we have three SQL examples on the usage of these clauses. I suggest that
we add a brief description of what each clause does.
> This might help the users to have a better understanding at first of how the said clauses
work.
> Here are the examples with a possible description:
> -- This query fetches the first row from T
> SELECT * FROM T FETCH FIRST ROW ONLY;
> -- This query skips the first 10 rows and fetches the following 10.
> -- It will fetch rows 11 through 20 (inclusive) from the table T, sorted by I
> SELECT * FROM T ORDER BY I OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY;
> -- This query skips the first 100 rows from T.
> -- If the table has less than 101 records, then an empty result set is returned.
> SELECT * FROM T OFFSET 100 ROWS;

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message