mathematical expressions SQL code example

Example 1: sql arithmetic operators

+ Add
– Subtract
* Multiply
/ Divide
% Modulo

Example 2: 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 (/)

Tags:

Sql Example

Related