select *
from (select ROW_NUMBER() over(order by state desc ) as rownumber,* from view_bug_search where 1=1 ) row_view
where row_view.rownumber between 151 and 180 order by state desc
使用
ROW_NUMBER() over(order by )
可以计算出所有的行数
再用between and 来进行分页