Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject Re: SELECT statement not working as intended
Date
Msg-id alpine.LNX.2.00.1110101544230.11484@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: SELECT statement not working as intended  (Henry Drexler <alonup8tb@gmail.com>)
Responses Re: SELECT statement not working as intended  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: SELECT statement not working as intended
Next
From: John R Pierce
Date:
Subject: Re: SELECT statement not working as intended