The SQL SELECT statement retrieves data from a table in the Fernhill SCADA database. The format of the SELECT statement is:
select-statement ::=
SELECT [ ALL | DISTINCT ] select-list
table-expression
The SELECT Statement can be used on any table in the Fernhill SCADA database.
SELECT FullName, Value, Units, DataSource FROM TagDataPointAnalog
SELECT FullName, Value, DataSource FROM TagDataPointAnalog WHERE Units='Amps'
SELECT FullName, StateDesc, DataSource FROM TagDataPointDigital
SELECT TypeLabel,COUNT(*) AS "Count" FROM TagCore GROUP BY TypeLabel
SELECT TypeLabel,COUNT(*) AS "Count" FROM TagCore GROUP BY TypeLabel ORDER BY "Count" DESC
SELECT StateAsText,COUNT(*) AS "Count" FROM AlarmEvent.Alarms GROUP BY StateAsText
Fernhill SCADA .NET Framework Data Provider
To learn about the .NET Framework Data Provider for Fernhill SCADA (FernhillSoftware.Data.FernhillScadaClient).
To learn about the ODBC driver in Fernhill SCADA.
To learn about the SQL Test Tool.
For the meaning of terms used in Fernhill SCADA.