已知表myobject(objectid int)

create table myobject(objectid int) row format delimited fields terminated by ',' stored as textfile;

按照objectid进行分页,其中objectid在表myobject中是唯一的(不重复)数据。

对表myobject进行分页

select t11.* from
(
select row_number() over (order by t10.objectid) as rnum ,t10.*
from myobject t10
)t11
where t11.rnum between 1 and 50;
05-11 11:27