Details
-
Improvement
-
Status: Closed
-
Major
-
Resolution: Duplicate
-
None
-
None
-
None
Description
I suggest to add an SQL syntax to limit the result set of a query to a specific range of rows.
For example:
SELECT ... FROM ... LIMIT n OFFSET n
or (less flexible because without offset):
SELECT TOP n ... FROM ...
See also: http://troels.arvin.dk/db/rdbms/#select-limit-offset
Attachments
Issue Links
- duplicates
-
DERBY-581 Modify SQL to skip N rows of the result and return the next M rows
- Closed