Select List (SQL)

Introduction

The Select List defines the columns in a query result.

Syntax

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

select-sublist ::=
  derived-column
  | qualified-asterisk

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

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

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

Remarks

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

Each item in the comma separated list can be:

Examples

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.

Glossary

For the meaning of terms used in Fernhill SCADA.