1. Mike Bayer Avatar Mike Bayer
  2. Untitled project
  3. sqlalchemy_old
  4. Issues

MSSQL LIMIT/OFFSET

Issue #639 resolved
paj created an issue

MSSQL does not natively support LIMIT with an OFFSET, but it may be possible to emulate the behavior. One option is to use MSSQL 2005's ROW_NUMBER() function; another is just to seek the cursor by the offset.

Comments (2)

  3. Log in to comment
Assignee
–
Type
bug
Priority
minor
Status
resolved
Component
mssql
Milestone
–
Votes
0
Watchers
0
Jira: the preferred issue tracker for Bitbucket. Join the team!