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.
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.
- 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:
The UNION Operator