SQL•SQL Tutorial

SQL Operators

Overview

SQL operators are keywords and symbols used to perform operations with data values. SQL operators are used in SQL statements like SELECT, WHERE, LIKE, etc. SQL operators is categorized into the following types:

Arithmetic operators

Comparison operators

Compound operators

Bitwise operators

Logical operators

SQL Arithmetic Operators

Operator

Description

Example

+

Addition

Try it

Subtraction

Try it

*

Multiplication

Try it

/

Division

Try it

%

Modulus

Try it

SQL Comparison Operators

Operator

Description

Example

=

Loading lesson path

Learn/SQL/SQL Tutorial

SQL•SQL Tutorial

SQL Operators

Overview

SQL operators are keywords and symbols used to perform operations with data values. SQL operators are used in SQL statements like SELECT, WHERE, LIKE, etc. SQL operators is categorized into the following types:

Arithmetic operators

Comparison operators

Compound operators

Bitwise operators

Logical operators

SQL Arithmetic Operators

Operator

Description

Example

+

Addition

Try it

Subtraction

Try it

*

Multiplication

Try it

/

Division

Try it

%

Modulus

Try it

SQL Comparison Operators

Operator

Description

Example

=