16.10 - Example: Creating a Temporary Named Column - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

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;