select *
from (select rownum en, ta.*
from (select ri.info_detail_type,
ri.info_num,
rmx.reagent_num,
ri.info_batch,
ri.info_lot,
ri.info_icebox,
ri.info_store_date,
ri.info_expiration_date,
ri.info_store_user,
ri.info_store_place,
rmx.reagent_using_state,
rmx.reagent_qc_result,
rmx.reagent_remark
from reag_info ri
inner join reag_info_mx rmx on ri.info_id = rmx.info_id) ta
where rownum <= 5 + 0)
where en > 0
oracl 分页语句
最新推荐文章于 2020-06-16 13:05:55 发布