1、mysql
select * from table_name limit 10;
从第5条后面的记录开始查询往后查询10条
select * from table_name limit 5,10;
2、oracle
select * from table_name where rownum<10
3、db2
select * from table_name fetch first 10 rows only;
1、mysql
select * from table_name limit 10;
从第5条后面的记录开始查询往后查询10条
select * from table_name limit 5,10;
2、oracle
select * from table_name where rownum<10
3、db2
select * from table_name fetch first 10 rows only;