ccl007 wrote:
you know in mysql ,we can use limit to query certain number of rows from a
table in database like select * from table1 limit 2,7; what kind of sql
language should i use in derby to perform the same kind of function in derby
I believe you have hit FAQ 5.2:
http://db.apache.org/derby/faq.html#limit
If the answer to the FAQ is not satisfactory, you can vote for the
relevant JIRA issue(s) that suggest similar functionality in Derby SQL
(I found
http://issues.apache.org/jira/browse/DERBY-581), and/or get involved in
Derby development and help implement a solution... ;)
Tip: Search for "limit" in Nabble
(http://www.nabble.com/Derby-f356.html) to review similar requests and
their answers.
--
John
