Sql分页代码示例

select * from (
select ROW_NUMBER()over( order by id) orderid,* from test
) a where a.orderid between 1 and 20

posted @ 2018-06-07 10:28  zhaogaojian  阅读(134)  评论(0)  编辑  收藏  举报