Run a Query

About this task

You can run a query against the data that is contained in the Historian database tables. A query is a SET or SELECT statement, or a combination of both of these SQL statements. When you execute a SELECT or SET statement in the Historian Interactive SQL application, you can execute only one SET and one SELECT statement per query.

Procedure

  1. Access the Historian Interactive SQL application.
  2. If you want to run a saved query, select File > Open, and then select the query that you want to run.
  3. If you want to run a new query, enter your query in the Query Entry field.
  4. Select or press Ctrl+E.
    The query results appear.