如下查询第9条数据，注意大的范围在前，小的范围在后
(select a.OBJECT_NAME Name from all_objects a where owner = 'LISRO' and a.OBJECT_TYPE='TABLE' and rownum<10)
minus
(select a.OBJECT_NAME Name from all_objects a where owner = 'LISRO' and a.OBJECT_TYPE='TABLE' and rownum<9)
如下查询第9条数据，注意大的范围在前，小的范围在后
(select a.OBJECT_NAME Name from all_objects a where owner = 'LISRO' and a.OBJECT_TYPE='TABLE' and rownum<10)
minus
(select a.OBJECT_NAME Name from all_objects a where owner = 'LISRO' and a.OBJECT_TYPE='TABLE' and rownum<9)
本文标题：Oracle查询第几条数据
本文链接：https://www.haomeiwen.com/subject/dpiofltx.html
网友评论