WHERE Clause Examples | SQL SELECT Statements | Teradata Vantage - Example: Simple WHERE Clause Predicate - Advanced SQL Engine - Teradata Database

The following statement can be used to select the name and job title of every employee in Department 100. In this statement, the predicate dept_no=100 is the conditional expression.

     SELECT name, jobtitle      FROM employee      WHERE dept_no = 100;