column-name

Specifies the column to select.

See:	column-modifier
	SELECT Clause

Syntax

Required Argument

Details

Syntax

column-name

Required Argument

column-name

is one of the following:

column

is the name of a column.

table-name.column

is the name of a column in the table table-name.

table-alias.column

is the name of a column in the table that is referenced by table-alias.

view-name.column

is the name of a column in the view view-name.

view-alias.column

is the name of a column in the view that is referenced by view-alias.

Details

A column can be referred to by its name alone if it is the only column by that name in all the tables or views listed in the current query expression. If the same column name exists in more than one table or view in the query expression, then you must qualify each use of the column name by prefixing a reference to the table that contains it. Consider the following examples:

SALARY       /* name of the column */
EMP.SALARY   /* EMP is the table or view name */
E.SALARY     /* E is an alias for the table
                or view that contains the
                SALARY column */