为什么我想取前两条,top2报错,我查了下报错是系统表不支持top,然后我又换了方法还是不行。
https://blog.51cto.com/u_16270801/9644452 oracle前10参考
参考
mssql:select top 20 * from 表 order by zje
mysql/sqlite:select * from 表 order by zje limit 20
Oracle:select * from (select * from 表 order by zje) where rownum<=20 order by rownum asc