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 TagDataPointDigital

To select a subset of the columns from a table:

Select FullName,Value,Quality
From TagDataPointDigital

Further Information

Fernhill SCADA Structured Query Language (SQL)

To learn more about the SQL features in Fernhill SCADA.


For the meaning of terms used in Fernhill SCADA.