CC SQL 7. advanced data Filtering

• SELECT prod_id, prod_price, prod_name
• FROM products
• WHERE vend_id = 1003 AND prod_price <= 10;

• SELECT prod_name, prod_price
• FROM products
• WHERE vend_id = 1002 OR vend_id = 1003;

• SELECT prod_name, prod_price
• FROM products
• WHERE vend_id IN (1002,1003)
• ORDER BY prod_name;

• SELECT prod_name, prod_price
• FROM products
• WHERE vend_id NOT IN (1002,1003)
• ORDER BY prod_name;

NOT in MySQL MySQL supports the use of NOT to negate IN,BETWEEN, and EXISTS clauses. This is quite different from most other DBMSs that allow NOT to be used to negate any conditions.