SQL Operators

What is an Operator in SQL?
An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to
perform operation(s), such as comparisons and arithmetic operations.
Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement.
 Arithmetic operators
 Comparison operators
 Logical operators
 Operators used to negate conditions
SQL Arithmetic Operators :-
Assume variable a holds 10 and variable b holds 20, then :-

Here are simple examples showing usage of SQL Arithmetic Operators :-

SQL Comparison Operators :-

Assume variable a holds 10 and variable b holds 20, then :-

Consider the CUSTOMERS table having the following records :-

Here are simple examples showing usage of SQL Comparison Operators :-

SQL Logical Operators :-

Here is a list of all the logical operators available in SQL

Consider the CUSTOMERS table having the following records :-

Here are simple examples showing usage of SQL Comparison Operators :-