Open topic with navigation

select-element

A single item in a SELECT list

Format

{ [ [ Schema . ] Table . ] * | expression [ AS Alias ] }

Remarks

Specifies a single item in a select list.

The first form: Table.* adds all columns in the table to the select list.

The second form: expression [ AS Alias ] adds an expression with optional column alias to the select list.