6/13/2013

SQL: "IN" Condition

The syntax for the "IN" condition is:
[code=text]expression in (value1, value2, .... value_n);[/code]

SQL "IN" Condition - Character example
[code=text]SELECT *
FROM suppliers
WHERE supplier_name in ('IBM', 'Hewlett Packard', 'Microsoft');[/code]

[url]http://www.techonthenet.com/sql/in.php[/url]

No comments:

Post a Comment