如下查询第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
网友评论