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
本文共 252 字，大约阅读时间需要 1 分钟。
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
转载于:https://www.cnblogs.com/vayci/p/5984848.html