Hi Sorry, at the moment that is not possible.
Alternatively, you could use the SELECT .. LIMIT 1 and SELECT ... ORDER BY .. DESC LIMIT 1 syntax to do the same thing. -- Noel. On 2015-07-01 06:19 AM, [email protected] wrote:
Hello! Unfortunately there exist no built-in aggregate function FIRST(foo ORDER BY bar) and LAST(foo ORDER BY bar). So I want to implement my own user-defined aggregate function FIRST() and LAST(). But I have no idea how to include the argument/parameter "ORDER BY" into my user-defined aggregate function like the built-in GROUP_BY(foo ORDER BY bar). Has anyone an idea how to implement FIRST() and LAST() with "ORDER BY" parameter? Thanks! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]>. To post to this group, send email to [email protected] <mailto:[email protected]>. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
