| 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
| 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 |
| 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 |