oracle查询最后10条记录,再升序(im记录查询)

select * from (select  * from 表名  where ROWNUM <= 10 order by id desc)  where ROWNUM <= 10 order by id asc

版权声明:本文为wo0123456789wo原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。