mysql分页有limit语句写分页太好了 比如从记录2到记录3select * from table1 limit 1,2db2就比较烦一些select * from (select row_number() over() row, tmp.* from (select * from table1) tmp) where row>1 and row<4