Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > SQL syntax > SQL queries
 
SQL queries
The UNICOM Intelligence Data Model supports a basic select statement for querying data. Expressions are supported, however sub-queries and joins are not supported. By supporting only a single query per statement only a single result set is returned. This avoids the need to support multiple results per execution. Cursor support is only provided using the programmer interfaces and not using SQL. Some SQL extensions are supported to enable crosstabulation on categorical variables.
See also
Basic SQL queries
Aggregate functions
Advanced SQL queries
Hierarchical SQL queries
Advanced hierarchical SQL queries
Running the example queries in DM Query
SQL syntax