Oracle中查询
select * from table where rownum<=10;
DB2中查询
select * from table fetch first 10 rows only;
MySql中查询
select * from table limit 10;
select * from table where rownum<=10;
select * from table fetch first 10 rows only;
select * from table limit 10;
转载于:https://www.cnblogs.com/fxust/p/7158097.html