SQL Language Elements
This chapter describes syntactical elements of the SQL language which occur in SQL statements. The elements described here are generally represented in the statement descriptions in SQL Statement Descriptions by single parameter words.
Users not accustomed to writing SQL statements will need to refer to the syntax descriptions in this chapter in order to construct many of the full SQL statements.
The language elements dealt with here are summarized in the table below:
Operators Arithmetical, string operators, comparison, relational operators and logical operators. Value specifications Specifying fixed values in expressions. Default values Specifying default values in CREATE statements. Set functions AVG, COUNT, MAX, MIN, SUM. Scalar functions Scalar functions. CASE expression Expression by which a conditional value can be specified. CAST specification Data type conversion specification. Expressions General value specifications. Predicates Conditional statements (basic, quantified, BETWEEN, IN, LIKE, NULL, EXISTS, OVERLAPS predicates). Search conditions Composite predicates defining row subsets from tables. Select specification Language elements defining row/column subsets from tables. Joined tables Inner and outer join specifications. Select statements Combinations of one or more subselects. Escape clause Escape clause for vendor-specific SQL.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40