Arthmetic Operations with SELECT

tags: #sql

To compute arithmetic operations in a SELECT statement, you can use basic arithmetic operators such as:

• + (addition)
• - (subtraction)
• * (multiplication)
• / (division)
• % (modulus):

SELECT column1 + column2 AS result // returned as a result-set of the operation
FROM table_name;