Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A query is a request for data or information from a database table or a combination of tables. This data may be generated as results returned by the Structured Query Language (SQL) or as pictorial trend analyses (graphs or complex results, e.g.) trend analyses from data-mining tools.

Several different query languages may be used to perform a range of simple to complex database queries.

Most database administrators are familiar with SQL since it is the most well-known and widely used query language. 

There are a couple different ways to execute a query A query can be executed in a project through a couple different methods. Below you will find them listed with a short description.

...

After the selected table is loaded into the Subsub-query Structurestructure, a statement will be initialized at the bottom of the page. 

...

Statement Example

To better illustrate the Query Builder query builder feature, let’s create an example which assumes the following requirements for our query result:

  • Only the UTCTimestamp Ticks and HistoricalTag columns are required
  • All column names need to be easy to understandeasily understandable
  • Elements will be sorted in ascending order
  • We only want the HistoricaTag values between 10 and 35

...