My company is using H2 as a unit test platform as we move from a legacy system(s) into a microservices architecture. Some of our existing SQL is complex and requires the SQL Windowing functionality.
I would like to see you raise the priority for the following functions: - Full outer joins. - ROW_NUMBER() OVER([PARTITION BY columnName][ORDER BY columnName]). - Window functions: RANK() and DENSE_RANK(), partition using OVER(). select *, count(*) over() as fullCount from ... limit 4; - Support running totals / cumulative sum using SUM(..) OVER(..). Thank you, Joe -- 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.
