1.mysql limit
-
select * from table limit 10,20
2.oracle 自带rownum
select
*
from
(
select
a.*,rownum rc
from
表名
where
rownum<=endrow) a
where
a.rc>=startrow
3.db2 rownumber() over()
as
rc
select
*
from
(
select
rownumber() over()
as
rc,a.*
from
useras
a)
where
rc
between
startrow
and
endrow