oracle SQL LIMIT
oracle 不能使用limit
- Oracle12c(12.1) 之前
SELECT * FROM RQGLB.APPLY_STATION_INFO where rownum <= 1
Oracle12c(12.1) 之后
SELECT * FROM RQGLB.APPLY_STATION_INFO OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY
本文来自博客园,作者:vx_guanchaoguo0,转载请注明原文链接:https://www.cnblogs.com/guanchaoguo/p/17236221.html