实现查询最新10条数据方法:
select * from 表名 order by id(主键) desc limit 10
将数据再倒序一次,要用嵌套函数:
SELECT * FROM (select * from 表名 order by id desc limit 10) aa ORDER BY id
福利:ORACLE查询sql
select * from (select * from emp t order by t.id desc) demp where rownum<6
实现查询最新10条数据方法:
select * from 表名 order by id(主键) desc limit 10
将数据再倒序一次,要用嵌套函数:
SELECT * FROM (select * from 表名 order by id desc limit 10) aa ORDER BY id
福利:ORACLE查询sql
select * from (select * from emp t order by t.id desc) demp where rownum<6