Bookshelf Home | Contents | Index | PDF |
Siebel Business Analytics Server Administration Guide > SQL Reference > SQL Syntax and Semantics > SELECT Query Specification SyntaxThe SELECT statement is the basis for querying any structured query language (SQL) database. The 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 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.
|
Siebel Business Analytics Server Administration Guide |