Arithmetic & Aliases
Published September 28, 2026
By Sai Sree Ram Gundepudi
Arithmetic Expressions and Aliases
Arithmetic
SQL allows basic arithmetic operations:
SELECT first_name, salary + 1000 AS updated_salary FROM employees;Aliases
You can use AS to rename columns in the result set:
SELECT salary * 12 AS annual_salary FROM employees;