AppDividend
Latest Code Tutorials

SQL Operators Tutorial With Example From Scratch

0

SQL Operators Tutorial With Example From Scratch is today’s topic. SQL operator is the reserved word or a character used primarily in the SQL statement’s WHERE clause to operate (s), such as comparisons and arithmetic operations. These reserved characters or words are known as the operators in SQL. These Operators are used to specify the conditions in the SQL statement and to serve as the conjunctions for multiple conditions in the statement. We have covered SQL Datatypes in our blog. Please check out that as well.

SQL Operators

There are three types of Operators in SQL.

  1. Arithmetic operators
  2. Comparison operators
  3. Logical operators

#SQL Arithmetic Operators

SQL Arithmetic operators are used to perform mathematical calculations like addition, subtraction, multiplication, division, and modulus in SQL statements.

See the following arithmetic operators.

Operators Descriptions Example
+ (Addition) The + operator is used to add containing values of both operands x + y will give 11
– (Subtraction) The – operator subtracts right-hand operand from the left-hand operand x – y- will give -11
* (Multiplication) The * operator multiplies both operand’s values x * y will give 1100
/ (Division) The / operator divides left-hand operand by right-hand operand x / y will give 11
% (Modulo) The modulo operator divides left-hand operand by right-hand operand and returns reminder x % y will give 0

 

#SQL Comparison Operators

Comparison operators in SQL are used to find a relation between the two columns. For example, if we want to compare the values of two columns in SQL statements.

See the following table of Comparison Operators in SQL.

Operator Description Example
= The = operator checks if the values of the two operands are equal or not, if yes then a condition becomes true. (a = b) is not true.
!= The != operator checks if the values of a two operands are equal or not if the values are not equal, then that condition becomes true. (a != b) is true.
<> The <> operator checks if the values of two operands are equal or not, if the values are not equal, then condition becomes true. (a <> b) is true.
> The > operator checks if the value of the left operand is greater than a value of the right operand, if yes then that condition becomes true. (a > b) is not true.
< The < operator checks if the value of a left operand is less than a value of the right operand, if yes then that condition becomes true. (a < b) is true.
>= The >= operator checks if a value of the left operand is greater than or equal to a value of the right operand, if yes then the condition becomes true. (a >= b) is not true.
<= The <= operator checks if a value of the left operand is less than or equal to a value of the right operand, if yes then the condition becomes true. (a <= b) is true.
!< The !< operator checks if a value of the left operand is not less than a value of the right operand, if yes then condition becomes true. (a !< b) is false.
!> The !> operator checks if a value of the left operand is not greater than a value of the right operand, if yes then condition becomes true. (a !> b) is true.

#SQL Logical Operators

Logical operators in the SQL are used to perform the logical operations on the given expressions in SQL. There are many operators in the SQL which are used in the SQL statements in the WHERE clause.

See the following Logical Operator in SQL.

Operators Descriptions
ALL The + operator is used to add the containing values of both the operands.
AND The – operator subtracts a right-hand operand from the left-hand operand.
ANY The * operator multiplies both of the operand’s values.
BETWEEN The / operator divides the left-hand operand by right-hand operand.
IN The modulo operator divides a left-hand operand by right-hand operand and returns reminder.
NOT The NOT operator reverses a meaning of the logical operator with which it is used. E.g., NOT EXISTS, NOT BETWEEN, NOT IN, etc. This is the negate an operator.
OR The OR operator is used to combine the multiple conditions in an SQL statement’s WHERE clause.
EXISTS The EXISTS operator is used to search for a presence of the row in the specified table that meets specific criteria.
LIKE The LIKE operator is used to compare the value to similar values using wildcard operators.

 

Finally, SQL Operators Tutorial With Example From Scratch is over.

Leave A Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.