I'm not sure what are you trying to implement, but may be select * from SomeTable where someGroup = 'someValue1' order by someColumn limit 1 union select * from SomeTable where someGroup = 'someValue2' order by someColumn limit 1 union ....
Will work? Could you provide you db schema, may be we could give a better answer, On Thu, May 26, 2016 at 9:12 AM, 张鹏鹏 <[email protected]> wrote: > Hi, > I want to implement "Get top 1 row of each group" program. > I think If I could use Continuous Queries and "window Functions" in > sql,it's easier. > > > 2016-05-25 21:30 GMT+08:00 vkulichenko <[email protected]>: > >> Hi, >> >> ROWNUM is not supported, and I'm not sure it's possible to properly >> implement it in the distributed environment. >> >> How do you intend to use it? >> >> -Val >> >> >> >> -- >> View this message in context: >> http://apache-ignite-users.70518.x6.nabble.com/How-can-I-use-H2-database-ROWNUM-function-tp5161p5190.html >> Sent from the Apache Ignite Users mailing list archive at Nabble.com. >> > > -- Alexey Kuznetsov GridGain Systems www.gridgain.com
