oracle分页查询

select * from (select t.*,rownum startPage from data_attr t where rownum<=(5*2) and sensor_id='CCD') where startPage>=(5*(2-1)+1)

原文地址:https://www.cnblogs.com/boshen-hzb/p/6834236.html