Yes, Job is correct: support for subquery is in-progress, but not yet implemented. In the meantime, you'll need to run this as two separate queries:
select max(time) from session;
select * from session where time = the_max;

Performance-wise, there will not be much difference for this query.


On Mon, Jun 2, 2014 at 9:30 PM, Job Thomas <> wrote:
Hi ,

The subquery feature is not supported in Phoenix.

Thanks & Regards
Job M Thomas


From: Pham Phuong Tu []
Sent: Tue 6/3/2014 9:27 AM
Subject: How to use subquery with Phoenix

Hi guys,

I have a question is how to use this kind of query with Phoenix?

" select * from session where time = (select max(time) from session); "

Thanks a lot.