pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mauricio Fernandez A. <mfacontacto@ono.com>
To: pgsql-sql@postgresql.org
Subject: Anual Query
Date: Mon, 28 Nov 2005 17:20:25 +0100
Message-ID: <KPEAKEDEHEPGJLOLEDMBEEJNCDAA.mfacontacto@ono.com> (raw)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



Hello,

Can any of you help me with this query?,  I need to retrieve the
sum(units) and sum(cost) for each client in every month in the same
row, something like this:

client|UnJan|CostJan|UnFeb|CostFeb|UnMar|CostMar ...	|UnDec|CostDec
- --------------------------------------------------------------------
100058|580	|47384  |746  |87438  |536  |21653	...	|857	|754875	(wrong
data, just to show)

Now I get this result using several querys (one for month and worse
for client too) but this, of course its too expensive.

Here is a table sample.

 orderId  | client  | date	  | product | Un | cost
- ------------------------------------------------------
 1001299  | 100058  | 20050103  | 759936  | 1  | 2375
 1001299  | 100058  | 20050103  | 759928  | 1  | 2375
 1001300  | 100078  | 20050103  | 759936  | 1  | 2375
 1001301  | 100017  | 20050103  | 759928  | 1  | 2375
 1001302  | 100009  | 20050103  | 759936  | 2  | 4750
 1001302  | 100009  | 20050203  | 756304  | 1  | 6669
 1001303  | 100009  | 20050203  | 759936  | 2  | 4750
 1001304  | 100005  | 20050203  | 759936  | 20  | 47500
 1001306  | 100013  | 20050203  | 759936  | 2  | 4750
 1001306  | 100013  | 20050203  | 759928  | 2  | 4750
 1001307  | 100013  | 20050203  | 759936  | 4  | 9500
 1001308  | 100013  | 20050203  | 759936  | 2  | 4750
 1001309  | 100050  | 20050303  | 759936  | 2  | 4750
 1001310  | 100050  | 20050303  | 759936  | 4  | 9500

....

Thanks for any idea.

Mauricio Fernández A.
Ingeniero de Sistemas
U. Autónoma de Manizales


-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.0.2i

iQA/AwUBQ4sgNc4irmZP1c6WEQLcPgCeLQNXphTXFXqVFZcKxrIO7aAfCEMAn397
jOO4lULVn/3bPLm6du7hGJeR
=YSsL
-----END PGP SIGNATURE-----




view thread (2+ messages)  latest in thread

Message-ID: <KPEAKEDEHEPGJLOLEDMBEEJNCDAA.mfacontacto@ono.com>
Permalink:  ../KPEAKEDEHEPGJLOLEDMBEEJNCDAA.mfacontacto@ono.com/
Also on:    postgresql.org/message-id/KPEAKEDEHEPGJLOLEDMBEEJNCDAA.mfacontacto@ono.com

 · 

reply
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: mfacontacto@ono.com
  Subject: Re: Anual Query
  In-Reply-To: <KPEAKEDEHEPGJLOLEDMBEEJNCDAA.mfacontacto@ono.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