From: John Fabiani <johnf@jfcomputer.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: using the aggregate function max()
Date: Thu, 22 Sep 2011 19:49:20 -0700
Message-ID: <201109221949.20671.johnf@jfcomputer.com> (raw)
Hi,
I need a little help understanding how to attack this problem.
I need to find the max(date) of a field but I need that value later in my
query.
If I
select max(x.date_field) as special_date from (select date_field) from table
where ...)x
I get one row and column.
But now I want to use that field in the rest of the query
select y.*, max(x.date_field) as special_date from (select date_field) from
table where ...)x
from aTable y where y.somefield = special_date.
The above only returns one row and one column the "special_date."
How can I use the aggregate field "special_date" in the rest of the query? Or
is there some other way?
Johnf
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: johnf@jfcomputer.com
Subject: Re: using the aggregate function max()
In-Reply-To: <201109221949.20671.johnf@jfcomputer.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox