OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Compute

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Compute [message #126233]

Fri, 01 July 2005 15:03

SRB22
Messages: 1
Registered: June 2005
Location: CA

Junior Member

I am new to SQLPLUS and am trying to follow the User's Guide and Reference to do a simple sum on a column that is a number data type, when I run this sample:

Compute sum of WON on WON

 SELECT TEAM, WON, LOST, TIED, CANCELLED, RAINOUT, M_UP FROM hockey
 ORDER BY TEAM;
 I get this:
Fri Jul 01
                                   Professional Hockey Teams

Team        WON Lost TIED CANCELLED Rain-out Date
----------- --- ---- ---- --------- -------- ---------
BLUES        56    7    3         2        1 05-JUN-73
CANADIENS    44    5    0         1        2 22-OCT-73
CANUCKS      43    2    5         7        1 22-OCT-73
ISLANDERS    54    6    2         7        1 24-NOV-73
MAPLE LEAFS  34    8    3         5        2 20-APR-73
            ---
            ###

My skills aren't too good yet. Can someone point me in the right direction to get a total for WON?

Thanks,

Report message to a moderator