--查询前10条数据
select * from MID_EHR_STAFF where rownum<10;--查询第5~10条的记录，minus（减）select * from MID_EHR_STAFF where rownum<10 minus select * from MID_EHR_STAFF where rownum<4;
本文共 226 字，大约阅读时间需要 1 分钟。
--查询前10条数据
select * from MID_EHR_STAFF where rownum<10;--查询第5~10条的记录，minus（减）select * from MID_EHR_STAFF where rownum<10 minus select * from MID_EHR_STAFF where rownum<4;
转载于:https://www.cnblogs.com/hyq0002013/p/5650286.html