Question

"商品"表に対するSQL文と同じ結果が得られるSELECT文はどれか。

[SQL文]
SELECT * FROM 商品 WHERE 仕入先ID IN ('M002', 'M004')

Accepted Answer

c：SELECT * FROM 商品 WHERE 仕入先ID = 'M002' OR 仕入先ID = 'M004'

Answer

a：SELECT * FROM 商品 WHERE 仕入先ID = 'M002' AND 仕入先ID = 'M004'

Answer

b：SELECT * FROM 商品 WHERE 仕入先ID = 'M002' INTERSECT SELECT * FROM 商品 WHERE 仕入先ID = 'M004'

Answer

d：SELECT * FROM 商品 WHERE 仕入先ID BETWEEN 'M002' AND 'M004'