Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A SQL select statement
Hi,
select item, sum(amount)
from ledger
group by item;
reg Kai
Jingyan <jingyan.xu_at_tst2000.com> wrote in article
<YYoN3.243$7d2.6856_at_nuq-read.news.verio.net>...
> Hi,
> the Ledger table below: I need to write a select statement to show the
> monthly amount paid for each item. Thanks for help. Jingyan Xu
> Name Null? Type
> ------------------------------- -------- ----
> ACTIONDATE DATE
> ACTION VARCHAR2(8)
> ITEM VARCHAR2(30)
> QUANTITY NUMBER
> QUANTITYTYPE VARCHAR2(10)
> RATE NUMBER
> AMOUNT NUMBER(9,2)
> PERSON VARCHAR2(25)
>
>
>
>
Received on Fri Oct 15 1999 - 03:32:13 CDT