That syntax is already supported by H2 since version 1.4.177 (see: http://www.h2database.com/html/changelog.html)
However, the "fetch first" variant is apparently not yet documented. Am Sonntag, 19. März 2017 10:29:11 UTC+1 schrieb Philippe Marschall: > > Now that 12c supports row limiting > <http://docs.oracle.com/database/121/SQLRF/statements_10002.htm#BABBADDD> > wouldn't it be easier to switch to this and implement the missing rest in > H2 rather than implement window functions? I'm not against implementing > window functions it just looks easier to me to extend the existing row > limiting support with Oracle syntax rather than implement window functions. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
