Issue Details (XML | Word | Printable)

Key: NUCRDBMS-733
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Add support for range offset/limit with SQLServer using OFFSET/FETCH keywords

Created: 30/Dec/13 09:43 AM   Updated: 06/Jan/14 11:19 AM   Resolved: 30/Dec/13 09:43 AM
Component/s: Code Structure
Affects Version/s: None
Fix Version/s: 3.2.10


 Description  « Hide
SQLServer 2012 has

[ OFFSET integer-literal {ROW | ROWS} ]
[ FETCH { FIRST | NEXT } [integer-literal] {ROW | ROWS} ONLY ]

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 30/Dec/13 09:43 AM
GitHub master adds support for this