OR in Teradata

The SQL "OR" condition allows you to create an SQL statement where records are returned when any one of the conditions are met. It can be used in any valid SQL statement.

Syntax:
SELECT columns
FROM tables
WHERE column1 = 'value1'
or column2 = 'value2';


Example:
SELECT * FROM Persons
WHERE FirstName='Tove'
OR FirstName='Ola'