On Mon, 10 Oct 2011, Henry Drexler wrote:
you are also grouping by sample date, those are the largest values for the criteria you have set out in the group by.
Henry, As I asked Merlin, what is necessary to get the date that maximum quantity was recorded? A nested SELECT? Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
