Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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:

Language Element
Summary
Section
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
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX