【MSSQL】Limit分頁

參考網址:http://www.dotblogs.com.tw/jimmyyu/archive/2009/11/09/11499.aspx
http://paco8822.pixnet.net/blog/post/52232214-ms-sql-%E5%88%86%E9%A0%81%E6%9F%A5%E8%A9%A2

user表的Structure:
id,name,tel,address

要抓30-40:
SQL2011、SQL Server CE4.0

SELECT * FROM user
OFFSET 30 ROWS
FETCH NEXT 10 ROWS ONLY;

之前的版本:

SELECT TOP 10 id,name FROM user
WHERE id not in
(SELECT TOP 30 id FROM user ODER BY id ASC)

ODER BY id ASC