[SQL]IN文で複数の値を条件にするサンプル

2021年8月26日

構文
SELECT 列名1,列名2
FROM　テーブル名
WHERE カラム名 IN (値1, 値2, …);

使用例

SELECT

CustomerName

, ContactName

, Address

FROM

Customers

WHERE

Country IN ('Germany', 'France', 'UK');

SELECT CustomerName , ContactName , Address FROM Customers WHERE Country IN ('Germany', 'France', 'UK');

SELECT
  CustomerName
  , ContactName
  , Address 
FROM
  Customers 
WHERE
  Country IN ('Germany', 'France', 'UK');

結果

CustomerName	ContactName	Address
Alfreds Futterkiste	Maria Anders	Obere Str. 57
Around the Horn	Thomas Hardy	120 Hanover Sq.

Posted by arkgame