I would like to sum up three column value.
ProjectID GETotal GMTotal GOTotal GrandTotal
10 1000 <null> 2000 ' I don't get sum value here because of null
12 8000 1000 500 9500
SELECT SUM(GETotal + GMTotal + GOTotal) AS GrandTotal, ProjectID, GETotal, GOTotal, GMTotal
GROUP BY ProjectID, GETotal, GOTotal, GMTotal
But i have to get 3000 for the ProjectID 10.
How do i do it if some of the column has null value.