how to do arithmetic operations in sql code example
Example 1: arithmetic operators in sql
You use the operators in any
clause (except the From clause)
With Date and Timestamp - can only use addition and subtraction
Add (+), Subtract (-), Multiply (*), Divide (/)
Example 2: sql arithmetic operators
+ Add
– Subtract
* Multiply
/ Divide
% Modulo