sqlserver分页语句
select * from(
select ROW_NUMBER() over(order by id desc) as num,* from tc_menu
)t where t.num>0 and t.num<=5
sqlserver分页语句
select * from(
select ROW_NUMBER() over(order by id desc) as num,* from tc_menu
)t where t.num>0 and t.num<=5
转载于:https://my.oschina.net/u/2377060/blog/787085