Additional unique types of queries can be created as outlined below:
- Simple queries — Queries without input columns can be created. Some examples of what might be selected in such a query include literal constants, random values or system values such as current date or time.
- Select Distinct — Use of the Select Distinct option results in only one of each duplicate row being returned. For example, the statement ‘SELECT DISTINCT product_code FROM table_A’ will return one each of every distinct value of product_code rather than the product_code for every row in the table.
- Table only in expert clause — Support is provided for queries in which a given table is only referenced in an expert clause.