Re: Sum If

From: "Daniel Hernandez" <breydan(at)excite(dot)com>
To: jim(at)contactbda(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: Sum If
Date: 2006-02-23 19:03:03
Message-ID: 20060223190303.5858C8A1E3@xprdmxin.myway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi Jim, Thanks for the tip, It worked!!!!!Thanks a lot!!!Daniel Hernndez.Tijuana, BC, Mxico.&quot;More you learn, more you earn&quot;.try select ...,sum(case when sales.itemname = 'some' then sales.count else 0 end) as &quot;Sales Candies&quot;from your_table_heregroup by ...

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

Browse pgsql-sql by date

  From Date Subject
Next Message Mario Splivalo 2006-02-23 20:07:58 Re: 'locking' the SELECTs based on indices...
Previous Message Jim Buttafuoco 2006-02-23 18:09:33 Re: Sum If