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 -> A SQL select statement

A SQL select statement

From: Jingyan <jingyan.xu_at_tst2000.com>
Date: Thu, 14 Oct 1999 23:14:47 -0700
Message-ID: <YYoN3.243$7d2.6856@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 - 01:14:47 CDT

Original text of this message

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