sum of the column data of the same row

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Vladan SSC-Insane Points: 22072 More actions · Answer 1

Hi,

that's simple, just add these columns:

SELECT Number, Name, Jan+Feb+March+April as Total

FROM yourtable

If this is not the correct solution, please explain what is the problem with it.

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 2

Hey,

I am sorry. I found the solution ,ofcourse a simple one which is just to add the columns.

Thanks.