declare @page int --頁碼declare @pagecount int;--每一頁顯示的記錄數set @page=2set @pagecount=6select * from (select *,row_number() over( order by id asc) as row from ADTypes) as a where row between (@page*@pagecount-@pagecount+1) and (@page*@pagecount)