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

Home -> Community -> Usenet -> c.d.o.misc -> Re: A SQL select statement

Re: A SQL select statement

From: Kai Sodemann <Kai.Sodemann_at_memo.ikea.com>
Date: 15 Oct 1999 08:32:13 GMT
Message-ID: <01bf16f0$96db9bc0$6e49100a@pc910-sode.seurope.ikea.com>


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

Original text of this message

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