Hi, Window functions are not supported, but it looks like you're simply querying maximum balance for each group. Am I missing something?
In this case you can execute something like this: SELECT yyyappid, max(balance) FROM ... GROUP BY yyyappid Will this work for you? -Val -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/How-can-I-use-H2-database-ROWNUM-function-tp5161p5307.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
