select* from
(select *,row_number() over(order by code) as rownumber
from table)
as temp
where rownumber between 10 and 20
转载于:https://www.cnblogs.com/yqie/archive/2012/05/14/2499596.html
select* from
(select *,row_number() over(order by code) as rownumber
from table)
as temp
where rownumber between 10 and 20
转载于:https://www.cnblogs.com/yqie/archive/2012/05/14/2499596.html