Re: SELECT statement not working as intended - Mailing list pgsql-general

On Mon, 10 Oct 2011, Merlin Moncure wrote:

> remove the sample_date the group by and the select list.  by having it in
> there you are asking for the max for each specific sample date.

merlin,

   That tells me the max quant but not on what date. Do I write a nested
SELECT to get that, too?

Thanks,

Rich