SQL Query to sum accross the row

[cris1978]

Hi,

Can someone help to write a query that will sum the information across the row, not down the column.

nome_item Sunday Monday Tuesday Wednesday Thursday Friday Total
item1 12 5 5 9 4 23 58
item2 2 6 2 2 45 3 60
item3 3 7 3 3 4 3 23
item4 4 8 4 4 4 5 29

[azimmer]

Hi,

Can someone help to write a query that will sum the information across the row, not down the column.

nome_item Sunday Monday Tuesday Wednesday Thursday Friday Total
item1 12 5 5 9 4 23 58
item2 2 6 2 2 45 3 60
item3 3 7 3 3 4 3 23
item4 4 8 4 4 4 5 29

You just add up the columns like this:

SELECT nome_item, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, 
 Sunday+Monday+Tuesday+Wednesday+Thursday+Friday as Total
FROM mytable
 
 

[cris1978]

You just add up the columns like this:

SELECT nome_item, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, 
 Sunday+Monday+Tuesday+Wednesday+Thursday+Friday as Total
FROM mytable
 
 

------------------------------------------------------------------------------------------------------------

I run the query, but it's the results of the Total column is '0'.

Do you have any idea?

[azimmer]

------------------------------------------------------------------------------------------------------------

I run the query, but it's the results of the Total column is '0'.

Do you have any idea?

It works fine (I tried) so long as your days columns are of numeric type (i.e. int). If they are string (char, varchar -- why?), you need to cast them like this:

SELECT nome_item, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, 
cast(Sunday as int)+...+cast(Friday as int) as Total
FROM mytable
 

[cris1978]

It works fine (I tried) so long as your days columns are of numeric type (i.e. int). If they are string (char, varchar -- why?), you need to cast them like this:

SELECT nome_item, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, 
cast(Sunday as int)+...+cast(Friday as int) as Total
FROM mytable
 

__________________________________________________ ________

Thanks!!!

This works very fine!!