Table Expression (SQL)


The Table Expression allows filtering and grouping on a table-reference-list.


table-expression ::=
   [ where-clause ]
   [ group-by-clause ]

from-clause ::=
  FROM table-reference-list

where-clause ::=
  WHERE search-condition


A Table Expression allows filtering and grouping operations on a table-reference-list. If the optional where-clause and group-by-clause are omitted, the result of the table-expression is the same as the from-clause. Otherwise each optional clause is applies to the previously specified clause and the result is the result of the final clause.


An table expression that retrieves table names in the 'Core' schema:

SELECT T.Table_Name
    FROM information_Schema.Tables T
    WHERE T.Table_Schema = 'Core'

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.