Jump to content

SELECT ALL Query using IN


FooKelvin

Recommended Posts

The IN operator allows you to specify multiple values in a WHERE clause.

 

SQL IN Syntax

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);

 

Example
SELECT * FROM Customers
WHERE City IN ('Paris','London');
Link to post
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.