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 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.

Glossary

For definitions of the terms used in Fernhill SCADA.