rank() and partition are not yet implemented in H2. Not sure when they will get implemented because you are the first person who has spoken up with a definite need for them :-)
But if you feel like providing patches, we would love to have them :-) Jochen Schreiber wrote: > Hello guys, > > i have an sql statement which contains rank(). This statement comes > from oracle. Which is the translation for h2? > > select * from ( select nt.*,rank() over(PARTITION by protocol_id order > by concentration desc) as ranking from (select r.protocol_id, > concentration, min(p.short_name) from hts.rsc_all_retests r, > hts.rin_protocol p ... nt ) where ranking < 3 order by 1,2; > > I need a translation which works in h2 and in oracle databases. > > Greetz > > bladepit > -- 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.
