SQL Operators | SQL Tutorial for Beginners | G C Reddy |

https://www.gcreddy.com/2021/08/sql-operators.html
SQL Operators, Arithmetic Operators, Comparison Operators, Compound Operators, and Logical Operators. SQL Operators examples with SQL Where clause to form single and multiple Conditions.
An operator is a reserved word or a character used primarily in an SQL statement's WHERE clause to perform operation(s., such as arithmetic, comparisons and Logical operations.
Operators are used to specify conditions in an SQL statement and to serve as conjunctions for multiple conditions in a statement.
Important Categories of SQL Operators are,
1. Arithmetic operators
2. Comparison operators
3. Logical operators Etc...
-----------------------------
1. Arithmetic Operators:
Arithmetic operators can perform arithmetical operations on numeric operands involved.
2. Comparison Operators:
A comparison (or relational. operator is a mathematical symbol which is used to compare between two values.
Comparison operators are used in conditions that compare one expression with another. The result of a comparison can be TRUE, FALSE, or UNKNOWN (an operator that has one or two NULL expressions returns UNKNOWN..
3. Logical operators:
There are three Logical Operators namely, AND, OR, and NOT. These operators compare two conditions at a time to determine whether a row can be selected for the output. When retrieving data using a SELECT statement, You can use logical operators in the WHERE clause, which allows you to combine more than one condition.