Arithmetic & Aliases

Published on: July 26, 2025 | Published by: Sai Sreeram 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;