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