分页的SQL语句
select * from(
select b.*
from (select rownum rn,t.* from experimentdata t ) b
where rn<=355
)
where rn>1
计算记录总数
select count(*) from experimentdata t
分页的SQL语句
select * from(
select b.*
from (select rownum rn,t.* from experimentdata t ) b
where rn<=355
)
where rn>1
计算记录总数
select count(*) from experimentdata t