Contents
Arithmetic operators
Operator | Definition | Example |
---|---|---|
+ | Addition | SELECT 42 + 7; |
- | Subtraction | SELECT 42 - 7; |
* | Multiplication | SELECT 42 * 7; |
/ | Division | SELECT 42 / 7; |
% | Modulus | SELECT 42 % 7; |
Comparison operators
Operator | Definition | Example |
---|---|---|
= | Equal to | SELECT * FROM Products |
> | Greater than | SELECT * FROM Products |
< | Less than | SELECT * FROM Products |
>= | Greater than or equal to | SELECT * FROM Products |
<= | Less than or equal to | SELECT * FROM Products |
<> | Not equal to | SELECT * FROM Products |
Pros Main Features
- Easy to use with a learn-by-doing approach
- Offers quality content
- Gamified in-browser coding experience
- The price matches the quality
- Suitable for learners ranging from beginner to advanced
- Free certificates of completion
- Focused on data science skills
- Flexible learning timetable
Pros Main Features
- Simplistic design (no unnecessary information)
- High-quality courses (even the free ones)
- Variety of features
- Nanodegree programs
- Suitable for enterprises
- Paid Certificates of completion
Pros Main Features
- A wide range of learning programs
- University-level courses
- Easy to navigate
- Verified certificates
- Free learning track available
- University-level courses
- Suitable for enterprises
- Verified certificates of completion
Logical operators
Operator | True if |
---|---|
ALL | All of the subquery values meet the condition |
AND | All the conditions separated by AND are TRUE |
ANY | Any of the subquery values meet the condition |
BETWEEN | The operand is within the range of comparisons |
EXISTS | The subquery returns one or more records |
IN | The operand is equal to one of the listed expressions |
LIKE | The operand matches a pattern |
NOT | The condition(s) is NOT TRUE |
OR | Any of the conditions separated by OR are TRUE |
SOME | Any of the subquery values meet the condition |
Compound operators
Operator | Definition |
---|---|
+= | Add assignment |
-= | Subtract assignment |
*= | Multiply assignment |
/= | Divide assignment |
%= | Modulus assignment |
Bitwise operators
Note: while bitwise SQL operators might seem similar to the logical SQL operators, they convert integers into binary bits and then perform the operations on each of them. The result is always an integer.
Operator | Definition |
---|---|
& | Bitwise AND |
&= | Bitwise AND EQUALS |
| | Bitwise OR |
|= | Bitwise OR EQUALS |
^ | Bitwise exclusive OR |
^= | Bitwise exclusive OR EQUALS |
~ | Bitwise NOT |