SQL Reference

Chapter 5. Queries

A query specifies a result table.

A query is a component of certain SQL statements. The three forms of a query are:

• subselect
• fullselect
• select-statement.

There is another SQL statement that can be used to retrieve at most a single row described under SELECT INTO.

Authorization

For each table or view referenced in the query, the authorization ID of the statement must have at least one of the following:

• SYSADM or DBADM authority
• CONTROL privilege
• SELECT privilege.

Group privileges are not checked for queries contained in static SQL statements.

[ DB2 List of Books | Search the DB2 Books ]