phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: Subqueries: Missing "LPAREN"
Date Wed, 24 Sep 2014 19:39:12 GMT
Hi JM,

Think this sub-query feature is covered by PHOENIX-1168, for which a
check-in is expected very soon.


Thanks,
Maryann

On Wed, Sep 24, 2014 at 9:06 AM, Jean-Marc Spaggiari <
jean-marc@spaggiari.org> wrote:

> Hi,
>
> Is it possible to run sub-queries with Phoenix? Something like this:
>
> select * from "metadata" n where L = 1 AND R = (select max(R) from
> "metadata" z where n.A = z.A);
>
> Goel is to get all lignes where L=1 and R=max. Field "A" is the key.
>
> Thanks,
>
> JM
>



-- 
Thanks,
Maryann

Mime
View raw message