Comment on page
Lesson 10. Creating New Columns From Existing Data (Calculated Fields)
As you have seen already, it is possible to derive new columns from existing information. So far, we have done it with strings. Now we are going to do it with math.
SQL has all the basic math operators. You can do math on numeric fields to derive new values.
An Example Arithmetic Calculation
OrderQty * (UnitPrice - UnitPriceDiscount) AS CalculatedLineTotal
Copyright © 2020, Mass Street Analytics, LLC. All Rights Reserved.