Teradata Logical and Conditional Operators

Teradata supports the following logical and conditional operators. These operators are used to perform comparisons and combine multiple conditions.

BETWEEN Operator

BETWEEN operators are used to checking if a value is within a range of values.

Example

Consider the following student table.

The following example fetches records with RollNo in the range between 1001, 1002, and 1003.

When the above query is executed, it returns the student records with RollNo between 1001 and 1003.

IN Operator

IN operator is used to check the value against a given list of values.

Example

The following example fetches records with RollNo in 1001, and 1002.

The above query returns the following records.

NOT IN Operator

NOT IN command reverses the result of IN command. It fetches records with values that don't match with the given list.

Example

The following example fetches records with employee numbers, not in 1001 and 1002.

The above query returns the following output, such as:

AND Operator

AND operator is used to connecting different LOGICAL operators. All the conditions must be met for a specific row to be qualified.

Example

The following example fetches the student record whose first name is Peter, and the last name is Collin.

Above query returns the following output, such as:

OR Operator

OR operator is used to connecting between different Logical operators. Only one of the conditions needs to be true for a row to be qualified.

Example

The following example fetches the students whose first name is Robert OR the last name is Peterson.

Above query returns the following output, such as: