## Operators

Operators manipulate individual data items (operands) and return a result. Mimer SQL uses the following operators:

## Set Operators

## UNION or UNION ALL

Derives a final result set by combining two other result sets.

If you specify

`UNION ALL`

, the result consists of all rows in both results sets.If you only specify

`UNION`

, the final result set is the set of all rows in both of the result sets, with duplicate rows removed.See The UNION Operator for more information.

## EXCEPT or EXCEPT ALL

## Mimer SQL Experience

The except operator is used to combine two result sets to one where the combined result set is all records from the first result which is not present in the second result set. If except is specified without the`ALL`

quantifier, duplicates are removed from the combined result set. If`ALL`

is specified, duplicates are not removed.See The EXCEPT Operator for more information.## INTERSECT or INTERSECT ALL

## Mimer SQL Experience

The intersect operator is used to combine two result sets to one where the combined result set is the records that are present in both result sets. If intersect is specified without the`ALL`

quantifier, duplicates are removed from the combined result set. If`ALL`

is specified, duplicates are not removed.See The INTERSECT Operator for more information.## Arithmetical Operators

Arithmetical operators are used in forming expressions, see Expressions.

## Unary Arithmetical

## Binary Arithmetical

## String Operators

String operators are used in forming expressions, see Expressions.

## String

## Comparison and Relational Operators

Comparison operators are used to compare operands in basic and quantified predicates. Relational operators are used to compare operands in all other predicates. See Predicates.

Both comparison and relational operators perform essentially similar functions. However, comparison operators are common to most programming languages, while the relational operators are more or less specific to SQL.

## Comparison Operators

## Comparison operator

## Explanation

= equal to <> not equal to < less than <= less than or equal to > greater than >= greater than or equal to## Quantifiers

## Relational Operators

## Logical Operators

The operators

`AND`

and`OR`

are used to combine several predicates to form search conditions, see Search Conditions.The operator

`NOT`

may be used to reverse the truth value of a predicate in forming search conditions. This operator is also available in predicate constructions to reverse the function of a relational operator, see Search Conditions.## Standard Compliance

This section summarizes standard compliance concerning operators.

Mimer Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se |