Apache Pinot Docs
latest
Search
⌃K

SUB

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 Batch Quick Start.
select homeRuns, baseOnBalls, SUB(homeRuns, baseOnBalls) AS total
from baseballStats
WHERE teamID = 'ML1'
AND yearID = 1956
AND playerName = 'Henry Louis'
homeRuns
baseOnBalls
total
26
37
-11
Last modified 1yr ago