select * from (select t.*,rownum startPage from data_attr t where rownum<=(5*2) and sensor_id='CCD') where startPage>=(5*(2-1)+1)
boshen-hzb 2017-05-10 09:10 原文
select * from (select t.*,rownum startPage from data_attr t where rownum<=(5*2) and sensor_id='CCD') where startPage>=(5*(2-1)+1)