Neoview SQL Reference Manual (R2.4)

Examples of Search Condition

• Select rows by using a search condition composed of three comparison predicates joined by

AND operators:

select O.ordernum, O.deliv_date, OD.qty_ordered

FROM sales.orders O,

sales.odetail OD

WHERE qty_ordered < 9 AND deliv_date <= DATE '2008-11-01'

AND O.ordernum = OD.ordernum;

ORDERNUM DELIV_DATE QTY_ORDERED

---------- ---------- -----------

100210 2008-04-10 3

100210 2008-04-10 6

100250 2008-06-15 4

101220 2008-12-15 3

...

--- 28 row(s) selected.

• Select rows by using a search condition composed of three comparison predicates, two of

which are joined by an OR operator (within parentheses), and where the result of the OR

and the first comparison predicate are joined by an AND operator:

SELECT partnum, S.suppnum, suppname

FROM invent.supplier S,

invent.partsupp PS

WHERE S.suppnum = PS.suppnum

AND (partnum < 3000 OR partnum = 7102);

PARTNUM SUPPNUM SUPPNAME

------- ------- ------------------

212 1 NEW COMPUTERS INC

244 1 NEW COMPUTERS INC

255 1 NEW COMPUTERS INC

...

7102 10 LEVERAGE INC

--- 18 row(s) selected.

Search Condition 287