SAND CDBMS SQL Reference Guide
SELECT

SELECT commands (often called "queries") retrieve information from database tables or views, and display this information in the form of a results table. Forms of the SELECT statement (query expressions) are used as part of the CREATE VIEW statement, as well as in some INSERT statements.

Required Privileges

In order to select data from a table or view, the user authorization must own the table/view, own or possess OWNER privileges on the schema to which the table/view belongs, possess SELECT privileges on the table/view, or possess DBA privileges.

If querying a remote table, via either a linked table or a dynamic pass-through query, the user authorization named in the specified connection object must also own the remote table, own or possess OWNER privileges on the schema to which the table belongs, possess SELECT privileges on the table, or possess DBA privileges on the remote database.

Syntax

 

Topics:

SELECT Clauses:

• Select List Clause
• Value Expression Clause
• Table Expression Clause
• Remote Table Clause
• Joined Table Clause
• Qualified Join Clause
• Joined Table Expression Clause
• Group/Order Expression Clause

Description of SELECT Clauses

Optional SELECT Clauses:

• WHERE
• GROUP BY
• HAVING
• WITH SAMPLE OF
• ORDER BY
• FETCH FIRST...ONLY

The UNION Operator