select * from (
select a.*,rownum as a_rownum from (
select * from xj_xjb order by xm
) a where rownum<=40
) b where b.a_rownum>20
select a.*,rownum as a_rownum from (
select * from xj_xjb order by xm
) a where rownum<=40
) b where b.a_rownum>20