SQL Guide - select-element (Reference)

Open topic with navigation

You are here:

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.

Disclaimer

Geo SCADA Expert 2020

The Schneider Electric industrial software business and AVEVA have merged to trade as AVEVA Group plc, a UK listed company. Schneider Electric, Life is On Schneider Electric and EcoStruxure are trademarks and the property of Schneider Electric SE and are being licensed to AVEVA by Schneider Electric.