Difference between revisions of "IN OPERATOR"
Jump to navigation
Jump to search
(Created page with "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 e...") |
(No difference)
|
Revision as of 18:07, 24 October 2017
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');