I am trying to use the SQL Window Function LEAD. The statement looks like this:
SELECT id, lead(id) over (ORDER BY id ASC) AS id_succ FROM t ; But I always get this error: Function "LEAD" not found. I don't see what I am doing wrong here. I can find LEAD in the documentation, but I don't understand why it does not work. Do I need to enable it somehow? Here is the document reference: Window Function LEAD <http://www.h2database.com/html/functions.html#lead> Thanks for any help in advance. -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/aec728f6-ed1a-4cba-bdc2-dda0ac504d2b%40googlegroups.com.
