blocks|key|263316|text|根据组合键K(k1，...，kn)上的严格总顺序的最后一行：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263317|SELECT++*
FROM++++TableX+AS+o
WHERE+++NOT+EXISTS+(
++++++++++++SELECT++*
++++++++++++FROM++++TableX+AS+i
++++++++++++WHERE+++i.k1+>+o.k1
++++++++++++++++OR++(i.k1+=+o.k1+AND+i.k2+>+o.k2)
++++++++++++++++...
++++++++++++++++OR++(i.k1+=+o.k1+AND+i.k2+=+o.k2+AND+i.k3+=+o.k3+AND+...+AND+i.kn+>+o.kn)
++++++++)
;|code-block|syntax|javascript|263318|给定K是简单的(即不是复合的)的特殊情况，上面的缩写为：|263319|SELECT++*
FROM++++TableX+AS+o
WHERE+++NOT+EXISTS+(
++++++++++++SELECT++*
++++++++++++FROM++++TableX+AS+i
++++++++++++WHERE+++i.k1+>+o.k1
++++++++)
;|263320|请注意，要使此查询只返回一行，键必须排序，而不能有关联。如果允许关联，则此查询将返回与最大键关联的所有行。|263321|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

The last row according to a strict total order over composite key K(k1, ..., kn):

<pre><code>SELECT *
FROM TableX AS o
WHERE NOT EXISTS (
 SELECT *
 FROM TableX AS i
 WHERE i.k1 &gt; o.k1
 OR (i.k1 = o.k1 AND i.k2 &gt; o.k2)
 ...
 OR (i.k1 = o.k1 AND i.k2 = o.k2 AND i.k3 = o.k3 AND ... AND i.kn &gt; o.kn)
 )
;
</code></pre>

Given the special case where K is simple (i.e. not composite), the above is shortened to:

<pre><code>SELECT *
FROM TableX AS o
WHERE NOT EXISTS (
 SELECT *
 FROM TableX AS i
 WHERE i.k1 &gt; o.k1
 )
;
</code></pre>

Note that for this query to return just one row the key must order without ties. If ties are allowed, this query will return all the rows tied with the greatest key.

blocks|key|263325|text|SELECT+*+FROM+(
++++SELECT+*+FROM+table_name+ORDER+BY+sortable_column+DESC
)+WHERE+ROWNUM+=+1;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|263326|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT * FROM (
 SELECT * FROM table_name ORDER BY sortable_column DESC
) WHERE ROWNUM = 1;
</code></pre>

blocks|key|263334|text|你可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|263335|SELECT+*+FROM+(SELECT+your_table.your_field,+versions_starttime
+++++++++++++++FROM+your_table
+++++++++++++++VERSIONS+BETWEEN+TIMESTAMP+MINVALUE+AND+MAXVALUE)
WHERE+ROWNUM+=+1;|code-block|syntax|javascript|263336|或者：|263337|SELECT+your_field,ora_rowscn,scn_to_timestamp(ora_rowscn)+from+your_table+WHERE+ROWNUM+=+1;|263338|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can do it like this:

<pre><code>SELECT * FROM (SELECT your_table.your_field, versions_starttime
 FROM your_table
 VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE)
WHERE ROWNUM = 1;
</code></pre>

Or:

<pre><code>SELECT your_field,ora_rowscn,scn_to_timestamp(ora_rowscn) from your_table WHERE ROWNUM = 1;
</code></pre>

blocks|key|263361|text|select+*+from+table_name+ORDER+BY+primary_id+DESC+FETCH+FIRST+1+ROWS+ONLY;|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|263362|这是最简单的一个，没有执行子查询|unstyled|263363|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>select * from table_name ORDER BY primary_id DESC FETCH FIRST 1 ROWS ONLY;
</code></pre>

That's the simplest one without doing sub queries

blocks|key|479987|text|SELECT+*+FROM+
++MY_TABLE
WHERE+
++<your+filters>
ORDER+BY+PRIMARY_KEY+DESC+FETCH+FIRST+ROW+ONLY|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|479988|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>SELECT * FROM 
 MY_TABLE
WHERE 
 &lt;your filters&gt;
ORDER BY PRIMARY_KEY DESC FETCH FIRST ROW ONLY
</code></pre>

I want to get the last row, which I inserted into a table in an Oracle 11g Express database. 
How can I do this?

How to get the last row of an Oracle a table

数据库

我想要获取最后一行，它是我插入到Oracle 11g Express数据库的表中的。我该怎么做呢？

问如何获取Oracle a表的最后一行
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取Oracle a表的最后一行EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何获取Oracle a表的最后一行
EN