從列中選擇具有多個值的條件

Created: November-22, 2018

SELECT * FROM Cars  WHERE status IN ( 'Waiting', 'Working' )

這在語義上等同於

SELECT * FROM Cars  WHERE ( status = 'Waiting' OR status = 'Working' )

即 value IN ( <value list> ) 是析取的簡寫（邏輯 OR）。