How this query!

From: "Richard Susanto" <richard(at)orbisindonesia(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How this query!
Date: 2005-08-25 11:44:00
Message-ID: 62683.202.152.170.186.1124970240.squirrel@202.152.170.186
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lars Haugseth 2005-08-25 12:21:20 Re: How this query!
Previous Message Przemysław Nogaj 2005-08-25 08:52:11 pg_dumpall problem - duplicated users

Browse pgsql-sql by date

  From Date Subject
Next Message Hélder M. Vieira 2005-08-25 12:16:47 Re: table listing queries
Previous Message Sean Davis 2005-08-25 11:27:02 Re: table listing queries