Mastering PostgreSQL Databases: From Basics to Advanced/

...

/

Arithmetic and Comparison Operators in SQL

Arithmetic and Comparison Operators in SQL

Learn about arithmetic and comparison operators in SQL, with examples.

We'll cover the following...

Types of operators

Operators are used for specifying conditions in SQL statements. SQL supports various types of operators, which can be classified as follows:

  • Arithmetic operators

  • Comparison operators

  • Logical operators

Arithmetic operators

Arithmetic operators perform arithmetic operations on numeric data. The arithmetic operators supported by SQL are listed in the table below:

List of Arithmetic Operators

Operator

Description

+

Adds two numeric operands

-

Subtracts one numeric operand from another

*

Multiplies two numeric operands

/

Divides one numeric operand by another

%

Calculates the remainder of dividing two numeric operands

Press + to interact
SELECT
  3 + 4 as Sum,
  5 - 2 as Diff,
  6 * 8 as Mul,
  10 / 2 as Div,
  8 % 3 as Mod;

In the SQL query example above, we use various arithmetic operators to perform arithmetic operations on numeric data. The value of the first column returned is 3 + 4 = 7, the value of the second column returned is 5 - 2 = 3, the value of the third column returned is 6 * 8 = 48, the value of the fourth column returned ...