Manuel Gentile

Back to SQL Course - Back to Operators

What’s a SQL operator?

An operator in SQL is a character / word used in statements like SELECT, INSERT, UPDATE, DELETE on WHERE or HAVING clauses.

Types of SQL operators

Arithmetic

Performs math operation on numerical data, we can find addition, subtraction, multiplication, division and modulus.

Comparison

Compares two different data returning a boolean value (TRUE or FALSE), checking if equal, greater or lesser.

Logical

Creates conditional expressions that returns a boolean value (TRUE or FALSE).

We can find ALL, AND, ANY, BETWEEN, EXISTS, IN, LIKE, NOT, OR, IS NULL.

Set

Combines similar type of data from tables mixing the result of queries and returning a single result.

Its operators are UNION, UNION ALL, MINUS, INTERSECT.

Back to SQL Course - Back to Operators

---

Let’s connect

If you want to learn more about the topic, connect or send me a DM.