The flashcards below were created by user
dau108
on FreezingBlue Flashcards.
-
using the AND operator
- SELECT prod_id, prod_price, prod_name
- FROM products
- WHERE vend_id = 1003 AND prod_price <= 10;
-
usingthe OR operator
- SELECT prod_name, prod_price
- FROM products
- WHERE vend_id = 1002 OR vend_id = 1003;
-
using the IN operator
- SELECT prod_name, prod_price
- FROM products
- WHERE vend_id IN (1002,1003)
- ORDER BY prod_name;
-
using the NOT operator
- 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.
|
|