Oracle 取最近 10 条数据

Oracle About 111 words

SQL

select * from(
select * from test_table order by id desc
) where rownum < 10;

不能直接在一句语句中添加rownum的过滤。

Views: 1,936 · Posted: 2020-12-03

———— END ————

Give me a Star, Thanks:)

https://github.com/fendoudebb/LiteNote

扫描下方二维码关注公众号和小程序↓↓↓