This is a very bad information for me...:-( On 9 Jan., 15:26, Noel Grandin <[email protected]> wrote: > 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.
