arithmetic 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

Example 3: arithmetic expression 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 (/)