Watch this example on YouTube:
Here is my table:
I want to know average of Bonus, Salary and Gambling for each user.
The following query will calculate it:
Select CustomerName ,
(Select AVG(MyAverage) From (Values (Bonus), (Salary), (Gambling)) as TblAverage(MyAverage))
From Table3
No comments:
Post a Comment