[sqlite] Is it legal SQL to select a specific row of a group via a HAVING clause?

[Gabor Grothendieck]

On Tue, Sep 29, 2015 at 6:16 AM, Simon Slavin <slavins at bigfraud.org> wrote:

> I don't like using sub-SELECT and I would love to see another reader
> rephrase this using 'WITH' or a VIEW.
>

with sub as (select currency, price, max(day) from prices group by currency)
 select currency, price from sub;