240
个人博客地址: olook.me

DB2分页查询简单示例

    select * from (
        select a.* ,rownumber() over(order by create_time desc) as rowid from (
            select * from vip_recognition_recode) 
            a) tmp where  tmp.rowid <= 10 and tmp.rowid >=1

 

posted @ 2016-10-21 15:40  VayCi  阅读(7915)  评论(2编辑  收藏