select * from table1 fetch first 10 rows only :db2
select * from table1 where rownum <= 10: oracle
select top 10 * from table1
:sqlserver
select * from table1 limit 10:mysql
转载于:https://www.cnblogs.com/kimobolo/p/7019769.html
select * from table1 fetch first 10 rows only :db2
select * from table1 where rownum <= 10: oracle
select top 10 * from table1
:sqlserver
select * from table1 limit 10:mysql
转载于:https://www.cnblogs.com/kimobolo/p/7019769.html