Arithmetic and Comparison Operators in SQL

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:

Get hands-on with 1200+ tech skills courses.