針對某一子集合條件式的查詢(in 子句)

admin

select fields1,fields2,fields3 from table where fields1 in (1,2,3,4,5,6);
查詢針對資料表裡之欄位資料,給予查詢條件,當fields1之值包含1或2,3,4,5,6,則顯示出其資料
範例說明:
查詢distributors其資料表裡,包含distri_num,boss_name,company,之欄位資料,給予條件,只呈現出distri_num
欄位中包含1018或1014,1006,1001,1027等之資料,可下達如下之指令來查詢
select distri_num,boss_name,company from distributors where distri_num in (1018,1014,1006,1001,1027);
詳細範例說明如下圖