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

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

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;