AND in Teradata

The AND operator displays a record if all the conditions are true.

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


Example:
SELECT *
FROM suppliers
WHERE city = 'New York'
and type = 'PC Manufacturer';