ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vkulichenko <valentin.kuliche...@gmail.com>
Subject Re: How can I use H2 database ROWNUM() function
Date Mon, 30 May 2016 11:05:11 GMT
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.

Mime
View raw message