看过此博文后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.nKBCtrlNo AS kb_ctrl_num
，rr.nPbType AS playback_type
，rr.nDevID AS device_id
，rr.nProt AS protocol
，rr.nStreamValue AS stream_value
，rr.nStreamType AS stream_type
，rr.nBeInspect AS is_inspect
，rr.nMultID AS mult_id
，rr.nMultVer AS mult_ver
，rr.nMultSysID AS mult_sys_id
，rr.strInterAreaCode AS index_code
，'pass' AS device_index_code
FROM(
SELECT row_number() OVER (ORDER BY oo.ID ASC) AS rownumber，
* FROM(SELECT DISTINCT * FROM RegionRes o WHERE o.nType = 0 ) AS oo
) AS rr
WHERE rownumber > 10;
　　MySQL的分页查询语句：
SELECT DISTINCT
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.nKBCtrlNo AS kb_ctrl_num
，rr.nPbType AS playback_type
，rr.nDevID AS device_id
，rr.nProt AS protocol
，rr.nStreamValue AS stream_value
，rr.nStreamType AS stream_type
，rr.nBeInspect AS is_inspect
，rr.nMultID AS mult_id
，rr.nMultVer AS mult_ver
，rr.nMultSysID AS mult_sys_id
，rr.strInterAreaCode AS index_code
，'pass' AS device_index_code
FROM RegionRes rr
WHERE rr.nType = 0 ORDER BY rr.ID ASC LIMIT 10，500