phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Subqueries: Missing "LPAREN"
Date Wed, 24 Sep 2014 13:06:36 GMT
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

Mime
View raw message