Select query to display sum of all columns in a table

pradeep_123

hi all,

i am having a table which contain 3 records.let table name be EMP and columns are C1,C2 C3 which contains integer values.

i want to get sum of all rows of all columns. Suppose assume that C1 ,C2,C3 contains values (1,2,3) ,(4,5,6) and (7,8,9)

(1+2+3+4+5+6+7+8+9)=45.

i want total as single value as 45.
Can any one please help me to get the query.

This is my first post in this form.if any mistakes plz excuse.

Prajesh_v_p · Active User Joined: 24 May 2006 Posts: 111 Location: India

Why cant you try the below query:

Select sum(c1) + sum (c2) + sum (c3)
from table

Thanks,
Prajesh V P

pradeep_123

Thank you for ur answer.

but ,I think it will be very difficult if the table contains more than 10 columns .

dbzTHEdinosauer

dick scherrer · Posted: Sat Aug 23, 2008 5:52 pm Post subject:

Hello,