February 18th, 2004, 09:06 AM
How to make sum of columns
I'm using an Oracle Database which looks like this example
Example (Customer is stored with the amount of different T-Shirts)
Customer Tshirt(Blue) Tshirt(Black) Tshirt(white)
Peter 1 5 3
John 0 2 6
Silvia 5 0 2
Now i want to add a column which is called total to count the total amount of t-shirts per customer.
Does anybody can help me with this problem?
Thank you in advanced!!!
February 26th, 2004, 05:13 PM
why not move/ask the question to the "oracle database" thread
February 27th, 2004, 04:49 AM
select customer, t_shirt_blue + t_shirt_black + t_shirt_white