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
