Can anyone tell me how to find sum in database row wise

Question

I'm writing this code

SELECT (Mathematics+Tech_comm.+Prog_C) As Total FROM sem1

and its throwing error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '+Prog_C) As Total FROM sem1 LIMIT 0, 25' at line 1

Hi Deepak please check the link https://stackoverflow.com/questions/18246143/calculate-row-wise-sum-sql-server I think this will help you. — Subhankar Dutta, Oct 28 '19 at 20:26
If this is a column name [Tech_comm.] with a dot, you need to add backticks ` `Tech_comm.` ` — FanoFN, Oct 29 '19 at 05:57

score -1 · Answer 1 · answered Oct 28 '19 at 20:22

-1

SELECT SUM(col1 + col2 + col3) as Total FROM table

answered Oct 28 '19 at 20:22

blupointmedia

564
2
10

Can anyone tell me how to find sum in database row wise

1 Answers1