Tuesday, 26 May 2015

MS SQL - How to Calculate Sum of Multiple Columns in one row

Watch this example on YouTube:

Here is my table:

I want to know what is total of bonus, salary and gambling for each user
The following query will provide me with this info:

Select CustomerName,
 (Select Sum(Earnings)
  From (Values (Bonus), (Salary), (Gambling)) As tblSum(Earnings))
From Table3

No comments:

Post a Comment