Thank you very much, @Nicholas it's working like charm. On Tuesday, November 7, 2017 at 3:10:15 AM UTC+5:30, Nicholas Whitehead wrote: > > How about: > > *WITH RECURSIVE T(n) AS (* > * SELECT 1* > * UNION ALL* > * SELECT n + 1* > * FROM T* > * WHERE n < 100* > *)* > *SELECT SEQ_ID.NEXTVAL AS V FROM T -- Get next 100 entries from sequence > SEQ_ID * > > Or, just select the range: > > *SELECT MIN(V) START, MAX(V) END FROM (* > *WITH RECURSIVE T(n) AS (* > * SELECT 1* > * UNION ALL* > * SELECT n + 1* > * FROM T* > * WHERE n < 100* > *)* > *SELECT SEQ_ID.NEXTVAL AS V FROM T)* > > //Nicholas > >
-- 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.
