About the Data Vault SQL Reference
Introduction to SQL Reference for Informatica Data Vault
Date and Time Arithmetic
WHERE Clauses
UNION Operator
Parameterized Query
Functions
- Functions Overview
- ABS
- AVG
- CEILING
- CHAR
- COALESCE
- CONCAT
- COUNT
- DATE
- DATE (Date and Time)
- DAY
- DEC
- DIGITS
- EXP
- EXTRACT
- FLOOR
- HOUR
- IFNULL
- INT
- LASTDAY
- LEFT
- LEN
- LN
- LOG10
- LOWER
- LTRIM
- MAX
- MICROSECOND
- MIN
- MINUTE
- MOD
- MONTH
- NANOSECOND
- NULLIF
- PI
- POSITION
- POSSTR
- POWER
- REPLACE
- RIGHT
- ROUND
- RTRIM
- SECOND
- SIGN
- SQRT
- SUBSTRING
- SUM
- TIME
- TODAY
- TRIM
- UPPER
- YEAR

Data Vault SQL Reference

6.4.3
- 6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1

Back Next

BETWEEN Predicates

The BETWEEN operator can evaluate whether or not data values fall within the range of values indicated in the predicate.

Each occurrence of the expression x
is evaluated to determine if it sorts between and including the range values indicated by y
and z
(the range values in the BETWEEN clause are also part of the result set). The three variables above can consist of any combination of value expressions, although x
is typically a column name.

Note that the value of y
should be less than that of z
. Otherwise, in the case of literals, an error will be returned; in the case of numeric expressions, the predicate will always return FALSE.

The following query selects all Part table records with weight
column values between 15 and 18:

SELECT pno, pname
FROM part
WHERE weight BETWEEN 15 AND 18;

The following table displays the records retrieved:

pno	pname
P2	BOLT

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

BETWEEN Predicates

BETWEEN Predicates