On Fri, May 13, 2016 at 7:33 PM, <danap at dandymadeproductions.com> wrote: > Derby: > SELECT * FROM schemaTableName FETCH FIRST ROW ONLY > [...] > Oracle: > SELECT * FROM schemaTableName WHERE ROWNUM=1
Oracle 12c added FETCH FIRST ROW ONLY too. --DD https://oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1#top-n
