Home » SQL & PL/SQL » SQL & PL/SQL » Adding numbers within a column
Adding numbers within a column [message #36254] Tue, 13 November 2001 09:21 Go to next message
Wesley Chang
Messages: 1
Registered: November 2001
Junior Member
Does anybody know how to add a column together to get a grand total? For instance, I have a column field called Fee.
There are 6 values underneath this column, 10,10,10,10,10,10. How do I code an Oracle statement telling it to add all of the numbers underneath this column to give 60? Thanks!

----------------------------------------------------------------------
Re: Adding numbers within a column [message #36256 is a reply to message #36254] Tue, 13 November 2001 09:36 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
in sqlplus:
compute sum of sal on report
select name, sal from emp;

----------------------------------------------------------------------
Previous Topic: Re: How to Retrieve CLOB withADODB Command Parameter...?
Next Topic: Trigger - using select into
Goto Forum:
  


Current Time: Thu Mar 28 13:53:06 CDT 2024