oracle分页查询

select * from(select t.*,rownum no from(select * from prosystem order by productiondate asc)t) where (no>(3-1)*5 and no<=(3)*5)

"select * from (select t.*,rownum no from EMST_JC_ZZCJ t)where (no>(1-1)*20 and no<=(1)*20)"

"select * from (select t.*,rownum no from EMST_JC_ZZCJ t where ZZCJ Like '%s%')where (no>(1-1)*20 and no<=(1)*20)"