How fool am I ! Max is the right way! Thanks Val
2016-05-30 19:05 GMT+08:00 vkulichenko <[email protected]>: > 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. >
