On 10/10/11 3:45 PM, Rich Shepard wrote:
As I asked Merlin, what is necessary to get the date that maximum quantity was recorded? A nested SELECT?
the complication is, there can be more than one date with the same maximum value, so such a query would be ambiguous, or it would return multiple rows.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
