Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> A SQL select statement
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
![]() |
![]() |