Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select ID, FirstName, LastName
- From (SELECT ROW_NUMBER() OVER (ORDER BY ID)
- AS Row, ID, FirstName, LastName
- From TestTable
- )
- WHERE Row > 1 AND Row <= 10
- SELECT
- [Page].[ID],
- [Page].[FirstName],
- [Page].[LastName]
- FROM
- (
- SELECT TOP (10)
- [FirstRows].[ID],
- [FirstRows].[FirstName],
- [FirstRows].[LastName]
- FROM
- (
- SELECT TOP (20)
- [TestTable].[ID],
- [TestTable].[FirstName],
- [TestTable].[LastName]
- FROM
- [TestTable]
- ORDER BY
- [TestTable].[ID] ASC
- ) AS [FirstRows]
- ORDER BY
- [FirstRows].[ID] DESC
- ) AS [Page]
- ORDER BY
- [Page].[ID] ASC
Add Comment
Please, Sign In to add comment