select * from ( select rownum num,t.jhnf as aa,t.jhno,t.jb,t.planner,t.jks,t.sjjks, t.zjjc,t.sjjc,t.finisedwell,t.sjwjs,t.jjs,t.sjjjs,t.jhdate,t.note from p_gsnjcjh t order by num desc) a where num>=(select max(num)-10 from gsnjcjh) and num<=(select max(num) from gsnjcjh)
select * from ( select rownum num,t.jhnf as aa,t.jhno,t.jb,t.planner,t.jks,t.sjjks,
t.zjjc,t.sjjc,t.finisedwell,t.sjwjs,t.jjs,t.sjjjs,t.jhdate,t.note
from p_gsnjcjh t
order by num desc) a
where num>=(select max(num)-10 from gsnjcjh)
and num<=(select max(num) from gsnjcjh)