Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: sum of a column (development question)
You are making a simple query awful hard. Try something like this:
select to_char(inv_date,'YYYY'), sum(ord_tot) "Invoiced Totals"
from ar_inv_hdr
where inv_dt between to_date('01-jan-2006','dd-mon-yyyy') and sysdate
group by to_char(inv_date,'YYYY')
order by to_char(inv_date,'YYYY')
On 9/11/07, Lyall Barbour <lyallbarbour_at_sanfranmail.com> wrote:
>
> Hi again,
> Development question. User wants the sum of all the purchase orders
> for this year and last year. I'm trying to get it in the same select
> statement. I want something like this, but don't know how to get it.
>
> select sum(ord_tot) "TY Invoiced Totals",
> sum(ord_tot) "LY Invoiced Totals"
> from ar_inv_hdr
> where inv_dt between trunc(sysdate, 'YYYY') and sysdate
> and inv_dt between trunc(sysdate, 'YYYY')-1 and trunc(sysdate,
> 'YYYY')-365
>
> This, obviously, doesn't do what i want, but it's where i've gotten to so
> far. Do i need to select from the same table twice?
>
> Thanks,
> Lyall
>
> --
> We've Got Your Name @ www.mail.com!!!
> Get a FREE E-mail Account Today - Choose From 100+ Domains
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 11 2007 - 12:59:13 CDT