試題詳解

32.假設 Address 欄位為顧客縣市街道巷弄門牌號碼完整資料，下列哪一道 SQL 指令是「從 customers 資料表中取得住址在新竹縣市的顧客」？
(A) SELECT * FROM customers WHERE Address IS '新竹縣' OR '新竹市'；
(B) SELECT * FROM customers WHERE Address INCLUDE '新竹'；
(C) SELECT * FROM customers WHERE Address LIKE '新竹%'；
(D) SELECT * FROM customers WHERE Address EQUAL '新竹%'；