Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


Search Conditions


Search conditions are used in:

A search condition is built from one or more predicates linked by the logical operators AND and OR and qualified if desired by the operator NOT.

The general syntax of a search condition is:



Rules

Search conditions enclosed in parentheses may be used as part of more complex search condition constructions. A search condition is evaluated as follows:

The result of a search condition is evaluated by combining the results of the component predicates. Each predicate evaluates to true, false or unknown, truth tables are shown in Truth Tables.

WHERE and HAVING clauses select the set of values for which the search condition evaluates to true. CHECK clauses define the set of values for which the search condition does not evaluate to false, i.e. is either true or unknown.

Examples

Using WHERE

The WHERE condition determines which rows to select, for example:

 SELECT *
    FROM customer_details
    WHERE country_code = 'SE'

Using HAVING

The HAVING clause restricts the selection of groups. A HAVING clause may use a set function on the left-hand side of a comparison. See Mimer SQL User's Manual, Grouped Set Functions - the GROUP BY Clause.

Standard Compliance

This section summarizes standard compliance concerning search conditions.

Standard
Compliance
Comments
SQL-2003
Core
Fully compliant.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX