Select List (SQL)


The Select List defines the columns in a query result.


select-list ::=
  | select-sublist [ { , select-sublist } ]

select-sublist ::=
  | qualified-asterisk

derived-column ::=
  value-expression [ [ AS ] identifier ]

qualified-asterisk ::=
  identifier-chain '.' '*'

identifier-chain ::=
  identifier [{'.' identifier}]


The Select List can either be a single '*' (asterisk), or a comma separated list.

Each item in the comma separated list can be:


To select all columns from a table:

Select *
From TagDigital

To select a subset of the columns from a table:

Select FullName,Value,Quality
From TagDigital

Further Information

Fernhill SCADA Structured Query Language (SQL)

To learn more about the SQL features in Fernhill SCADA.


For definitions of the terms used in Fernhill SCADA.