Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

It took a while, but SQL Server 2012 introduced OFFSET/FETCH:

    SELECT * FROM items
    ORDER BY key
    OFFSET 100 ROWS
    FETCH NEXT 10 ROWS ONLY
(https://technet.microsoft.com/en-us/library/gg699618(v=sql.1...)


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: