Hi Folks -- I am a very new H2 user (my experience so far has been excellent), and have run into what might be my first minor issue, which is the behavior of the ROWNUM() function. As stated in the documentation, "The first row has the row number 1, and is calculated *before* ordering and grouping the result set" (the asterisks are mine). Another database ($QL $erver) assigns row numbers in a similar manner, but *after* ordering. The latter enables you to use the row number to JOIN a given row with the next and previous rows, which is very handy.
So....is there any way to get ROWNUM() to calculate the row number after the ordering of rows? If not, is there another mechanism in H2 which enables JOINs as described above? Thanks in advance for any thoughts or suggestions...best regards...TerryG --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/h2-database?hl=en -~----------~----~----~----~------~----~------~--~---
