Number of Expressions in SELECT Statements - Teradata VantageCloud Lake

All SELECT statements must have the same number of expressions.

If the first SELECT statement contains three expressions, all succeeding SELECT statements must contain three expressions.

You can use a null expression in a SELECT statement as a place holder for a missing expression.

In the following example, the second expression is null.

SELECT EmpNo, NULL (CHAR(5)) 
FROM Employee;