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

Compound Predicates

Compound predicates use the operators OR and AND. For example, to display the sno
column values for all suppliers in “PARIS” with a status
column value greater than 20, use the following query:

SELECT sno
FROM supplier
WHERE city = 'PARIS'
AND status > 20;

This SELECT command statement retrieves pno
column values for those parts that are either ‘RED’, or weigh more than 15 pounds:

SELECT pno
FROM part
WHERE color = 'RED'
OR weight > 15;

In complex queries, parentheses can be used to indicate the order of evaluation. The condition(s) surrounded by the innermost pair of parentheses are applied first.

SELECT pno, pname
FROM part
WHERE color = 'green'
OR (city = 'LONDON'
AND weight < 15);

This last query retrieves pno
and pname
column values of all parts that are either green, or are both made in London and have a weight less than 15.

The following table displays the query result:

pno	pname
P1	NUT
P2	BOLT
P4	SCREW

Rename Saved Search

Table of Contents

Data Vault SQL Reference

Data Vault SQL Reference

Compound Predicates

Compound Predicates