db2,oracle,mysql ,sqlserver限制返回的行数时间:2023-03-09 20:04:17 不同数据库限制返回的行数的关键字如下: ①db2 select * from table fetch first 10 rows only; ②oracle select * from table where rownum<=10; ③mysql select * from table limit 10; ④sqlServer select top 10 * from table;