17.10 - Example: Creating a Temporary Named Column - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

This syntax creates a temporary named column and uses it in a WHERE clause.

SELECT Name,((Salary + (YrsExp * 200))/12) AS Projection
FROM Employee
WHERE DeptNo = 600
AND Projection < 2500;