sum of a column (development question)
- From: "Lyall Barbour" <lyallbarbour@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 11 Sep 2007 12:32:37 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
