IN OPERATOR

From rbachwiki
Revision as of 18:09, 24 October 2017 by Bacchas (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The IN operator returns records matching one of the values listed in the condition. Oracle 11g syntax requires separating list items with commas, and the entire list must be enclosed in parentheses.

SELECT title, pubid
FROM books
WHERE pubid IN (1,2,5);
SELECT firstname, lastname, state
FROM customers
WHERE state IN('CA','TX');
SELECT firstname, lastname, state
FROM customers
WHERE state NOT IN('CA','TX');

Back To Top- Home - Category