This section contains reference documentation for the SUB function.
Difference between two values
Signature
SUB(col1, col2)
Usage Examples
These examples are based on the .
homeRuns
baseOnBalls
total
select homeRuns, baseOnBalls, SUB(homeRuns, baseOnBalls) AS total
from baseballStats
WHERE teamID = 'ML1'
AND yearID = 1956
AND playerName = 'Henry Louis'