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