Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL Crosstab Totals
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
![]() |
![]() |