Choosing Columns: The Select List

The select list frequently consists of a series of column names (separated by commas) or an asterisk (*, representing all columns).

The select list, however, can also include one or more expressions (separated by commas), where an expression is a constant, column name, function, subquery, or any combination of these connected by arithmetic or bitwise operators and parentheses. The select list has this syntax:

SELECT expression [, expression...]