# Complete Guide to SQL Math Operators

SQL math operators are easy to use and very powerful. They can help you to perform advanced analytics and calculations within your queries. We’ve put together this helpful guide to assist you in learning the various mathematical operations you can perform.

For any given SQL math operation, you should keep in mind that the data type and NULL values will impact how the database performs the calculation. Each article below will provide examples of these situations for the specific operator.

## Types of SQL Math Operators

There are three primary categories of operations that we cover:

- Basic math operators: addition, subtraction, multiplication, and division
- Math functions: functions built into the database for absolute values, exponents, square roots, and other advanced operations
- Aggregate functions: SUM(), MAX(), MIN(), AVG() and other aggregation functions

## SQL Code for Math Operators Guide

In order to help you work through each of the tutorials below, we’ve provided sample code to create the table and perform the initial inserts required. The code is available publicly on Github for each database platform that we cover in the tutorials.

## Basic Math Operations

These are all basic SQL math operators that work fairly consistently in all database servers such as MS SQL Server, MySQL, and PostgreSQL. These operations can be used on literal values, database fields, variables, and even in combination with aggregate functions.

### How to Add in SQL

### How to Divide in SQL

### How to Multiply in SQL

### How to Subtract in SQL

## Aggregate SQL Functions

Aggregate functions allow you to perform operations against multiple rows in your query.