Bookshelf: SELECT Usage Notes

Siebel Analytics Server Administration Guide > SQL Reference > SQL Syntax and Semantics >

SELECT Usage Notes

The Siebel Analytics Server treats the SELECT statement as a logical request. If aggregated data is requested in the SELECT statement, a GROUP BY clause is automatically assumed by the server. Any join conditions supplied in the query are ignored; the join conditions are all predefined in the repository.

The Siebel Analytics Server accepts the following SQL syntaxes for comments:

/* */ C-style comments
// Double slash for single-line comments
# Number sign for single-line comments

The Siebel Analytics Server supports certain subqueries and UNION, UNION ALL, INTERSECT, and EXCEPT operations in logical requests. This functionality increases the range of business questions that can be answered, eases the formulation of queries, and provides some ability to query across multiple business models.

The Siebel Analytics Server supports the following subquery predicates in any conditional expression (for example, within WHERE, HAVING, or CASE statements):

IN, NOT IN
>Any, >=Any, =Any, <Any, <=Any, <>Any
>Some, >=Some, =Some, <Some, <=Some, <>Some
>All, >=All, =All, <All, <=All, <>All
EXISTS, NOT EXISTS

Siebel Analytics Server Administration Guide
Published: 11 March 2004