From: Luis Magaña <joe666@gnovus.com>
To: PostgreSQL General <pgsql-general@postgresql.org>
To: PostgreSQL Novice <pgsql-novice@postgresql.org>
To: PostgreSQL SQL <pgsql-sql@postgresql.org>
Subject: For each record in SELECT
Date: 31 Jan 2003 15:21:17 -0600
Message-ID: <1044048077.1380.3.camel@kerberus> (raw)
Hi,
I have a question here:
I have a table with this fields:
month
description
amount
now I have to write a query that retrieves the sum of the amount from
the minimum month to the maximum month registered for each diferent
description.
Of course there are cases when a particular description has not record
for all the months in that period. I mean, suppouse you have this
records:
month description amount
-----------------------------------------------
June description1 100
July description1 500
August description1 600
June description2 300
August description2 400
how you write a query that outputs something like this:
June July August
------------------------------------------
description1 | 100 500 600
description2 | 300 0 400
My problem is for the 0 value.
I hope I've explained clearly my question.
Thanks for the help.
Best Regards.
--
Luis Magaña.
Gnovus Networks & Software.
www.gnovus.com
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: joe666@gnovus.com, pgsql-general@postgresql.org, pgsql-novice@postgresql.org
Subject: Re: For each record in SELECT
In-Reply-To: <1044048077.1380.3.camel@kerberus>
* 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