WHERE 字句操作符 。。。。 范圍 查詢 SELECT prod_name,prod_price FROM WHERE prod_price BETWEEN 2 AND 6; 注:WHERE 和 ORDER BY 一起用時,ORDER BY 在后面