MSSQL 與 MySQL Limit 相同功能之語法

JDP

MySQL:[code=sql]select * from table limit 5,30[/code]
MSSQL:[code=sql]select * from (select row_number() over (order by id) as row_num,* from table)
t where row_num between 5 and 30[/code]
Reference: http://tw.zhidao.baidu.com/question/2252883.html