Postgres Pro
Downloads
Home   >   mailing lists

Thread: How this query!

How this query!

From
"Richard Susanto"
Date:
Folks,
would you like help me how to query this case.

I have tbl_a, the fields are :
item_record
item_product_name
item_qty


if the data are :

item_record = 1,2,3,4,5,6
item_product_name = a,b,a,c,d,c,...
item_qty = 10,5,15,10,20,5,...

How the query to sum item_qty_total if i want the result :
item_product_name = a,b,c,d
item_qty_total = 25,5,15,20

Regards,
--
>>Richard Sitompul<<
Software Engineer
PT. Orbis Indonesia
http://www.orbisindonesia.com
http://richardsstp.3wsi.net

Re: How this query!

From
Lars Haugseth
Date:
* richard@orbisindonesia.com ("Richard Susanto") wrote:
|
| Folks,
| would you like help me how to query this case.
|
| I have tbl_a, the fields are :
| item_record
| item_product_name
| item_qty
|
|
| if the data are :
|
| item_record = 1,2,3,4,5,6
| item_product_name = a,b,a,c,d,c,...
| item_qty = 10,5,15,10,20,5,...
|
| How the query to sum item_qty_total if i want the result :
| item_product_name = a,b,c,d
| item_qty_total = 25,5,15,20

SELECT item_product_name, sum(item_qty) FROM tbl_a GROUP BY item_product_name;

--
Lars Haugseth

Re: How this query!

From
Bruno Wolff III
Date:
On Thu, Aug 25, 2005 at 18:44:00 +0700,
  Richard Susanto <richard@orbisindonesia.com> wrote:
> Folks,
> would you like help me how to query this case.

This question is off topic for the pgsql-admin list, it should have been
asked on the pgsql-sql list because it was a question about SQL. (I probably
wouldn't have said anything if it had been posted to the pgsql-general
or pgsql-novice lists, but it is definitely not a question even remotely
related to postgres administration.)

>
> I have tbl_a, the fields are :
> item_record
> item_product_name
> item_qty
>
>
> if the data are :
>
> item_record = 1,2,3,4,5,6
> item_product_name = a,b,a,c,d,c,...
> item_qty = 10,5,15,10,20,5,...
>
> How the query to sum item_qty_total if i want the result :
> item_product_name = a,b,c,d
> item_qty_total = 25,5,15,20

Use GROUP BY item_product_name and sum(item_qty). Something like:

SELECT item_product_name, sum(item_qty) AS item_qty_total
  FROM tbl_a
  GROUP BY item_product_name
  ORDER BY item_product_name
;