Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide > SQL Reference > SQL Syntax and Semantics >
SELECT Query Specification Syntax
The SELECT statement is the basis for querying any structured query language (SQL) database. The Siebel Analytics Server accepts logical requests to query objects in a repository, and users (or query tools) make those logical requests with ordinary SQL SELECT statements. The server then translates the logical requests into physical queries against one or more data sources, combines the results to match the logical request, and returns the answer to the end user.
The SELECT statement, or query specification as it is sometimes referred to, is the way to query a decision support system through the Siebel Analytics Server. A SELECT statement returns a table to the client that matches the query. It is a table in the sense that the results are in the form of rows and columns.
The following is the basic syntax for the SELECT statement. The individual clauses are defined in the subsections that follow.
The list of columns specified in the query. See SELECT List Syntax. The list of tables in the query, or a catalog folder name. Optionally includes certain join information for the query. See FROM Clause Syntax. Specifies any combination of conditions to form a conditional test. See WHERE Clause Syntax.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 11 March 2004 |