SQLSERVER分页

分页:

SELECT LastName, FirstName, EmailAddress
FROM Employee
ORDER BY LastName, FirstName, EmailAddress
OFFSET 14000 ROWS
FETCH NEXT 50 ROWS ONLY;

 

over!

posted on 2016-06-17 10:50  冰羽的世界  阅读(146)  评论(0编辑  收藏  举报