ORACLE、MYSQL、SQLSERVER数据分页查询

看过此博文后Oracle、MySql、SQLServer 数据分页查询,在根据公司的RegionRes表格做出了 SQLserver的分页查询语句: SELECT DISTINCT TOP 500 rr.ID AS id ,rr.strName AS name ,rr.nType AS res_type ,rr.nRegID AS region_id ,rr.strChanName AS channel_name ,rr.nChanNum AS channel ,rr.nSortID AS sort_id ,rr.nCamType AS camera_type ,rr