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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
