SQL statements begin with a verb and can include
clauses or names. For example:
SELECT PartNumber FROM PurchDB.Parts
| | | | | |
| | | owner | |
| | | name | |
| | | | |
statement | | table |
verb | | name |
| | |
column +----------------+
name |
|
FROM
clause
|
Statements always contain a verb, one or more words that
describe the action of the statement. A statement can also
contain one or more clauses. A clause is a group of names
and keywords describing what the verb should operate on. A
verb can operate on a named object, such as a table
or a column.
Some statements can contain expressions or search conditions.
Expressions specify a value. Search conditions screen data
against specific criteria:
SELECT * FROM PurchDB.Parts WHERE SalesPrice > 200.00
| | | | |
all | | expression |
columns | | |
| +-----------------+
| | |
| search condition |
| |
+-----------------------+
|
WHERE
clause
|
The syntax of SQL is fully described in chapters 7-10 of this
manual.