Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Crosstab Totals

SQL Crosstab Totals

From: Vincent Jones <vncntj_at_hotmail.com>
Date: 16 Apr 2003 12:03:44 -0700
Message-ID: <ba2a2d30.0304161103.5f2a244a@posting.google.com>


I want to take the Sum of Pledge_Amount when If_Yes_Pledge_Or_Credit_Card =2 This is part of a CrossTab Query.
Pledge is 'Currency'
If_Yes_Pledge_Or_Credit_Card is 'int'
Sum(Case o.If_Yes_Pledge_Or_Credit_Card When 2 Then Pledge_Amount

					Else ''
					End) '% of Total Yes $  on CC'
Received on Wed Apr 16 2003 - 14:03:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US