星空网 > 软件开发 > 数据库

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.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 rrWHERE 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


其他网站:

oracle,mysql,SqlServer三种数据库的分页查询的实例

 




原标题:Oracle、MySql、SQLServer数据分页查询

关键词:MYSQL

*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们: admin#shaoqun.com (#换成@)。

竞争对手都在刷单,到底该不该跟上?:https://www.ikjzd.com/articles/85
卖家争夺战!eBay控诉亚马逊非法挖第三方卖家:https://www.ikjzd.com/articles/8500
2018中国国际贸易便利化论坛开幕式今在深召开:https://www.ikjzd.com/articles/8503
Wish的机器算法原理之分类用户:https://www.ikjzd.com/articles/8507
Wish新政:Wish平台将实施“取消订单之罚款政策”:https://www.ikjzd.com/articles/8514
关于英国VAT20个问题须知!干货收藏!:https://www.ikjzd.com/articles/8516
春季热卖单品!空气净化器单周销售额近三十万!:https://www.kjdsnews.com/a/1836547.html
春季热卖单品!空气净化器单周销售额近三十万!:https://www.goluckyvip.com/news/188215.html
相关文章
我的浏览记录
最新相关资讯
海外公司注册 | 跨境电商服务平台 | 深圳旅行社 | 东南亚物流