Richard Connamacher wrote:
> This came up with an error too, but it pointed me in the right
> direction and was easy to fix. I needed to use an alias for the
> entire subquery too, so what finally worked is this:
>
> SELECT avg(minprice) FROM
> (SELECT min(price) AS minprice FROM weekly_
Thanks! That did the trick.
SELECT avg(minprice) FROM
(SELECT min(price) as minprice FROM weekly_supply_prices GROUP BY
month );
This came up with an error too, but it pointed me in the right
direction and was easy to fix. I needed to use an alias for the
entire subquery too, so what f
On Sun, Apr 02, 2006 at 04:03:03AM -0700, Richard Connamacher wrote:
> I've got a question, if anyone can help me out. I know how to use an
> aggregate function to, say, find the lowest price ever listed for a
> product. I also know how to combine that with a SELECT ... GROUP BY
> statement t
Hey all,
I'm new on this list, and have been playing with Postgres a lot this
week. (Love it, by the way.)
I've got a question, if anyone can help me out. I know how to use an
aggregate function to, say, find the lowest price ever listed for a
product. I also know how to combine that with
