AND NOT comm IN (.10,.12);
17.
17 BETWEEN
BETWEEN, .
:
SELECT *
FROM Customers
WHERE cname BETWEEN 'A' AND 'G';
18.
18 BETWEEN
, Grass Giovanni , BETWEEN. - BETWEEN . 'G' Giovanni, BETWEEN 'G' . ( ), Giovanni . Grass. BETWEEN . ( z).
LIKE
LIKE CHAR VARCHAR, , . .. , , . (wildkards) - -. LIKE:
(?) . , 'b?t' 'bat' 'bit', 'brat'.
(*) ( ). '*p*t' 'put', 'posit', 'opt', 'spite '.
, G ( 19):
SELECT *
FROM Customers
WHERE cname LIKE 'G*';
19: SELECT LIKE *
LIKE , , , . , Peal Peel. ( 20):
SELECT *
FROM Salespeople
WHERE sname LIKE 'P??l*';
20 SELECT LIKE (?)
?, , 'P' 'l', Prettel . 'l' .. * - . , sname - VARCHAR.
? *. LIKE , [*].
|
|
, Salespeople, * (: Po*l). . :
SELECT *
FROM Salespeople
WHERE sname LIKE '*[*]*';
? (: Po?l), :
SELECT *
FROM Salespeople
WHERE sname LIKE '*[?]*';
NULL
NULL , NULL. NULL , NULL, , , - . , , - , NOT () - , NOT () - .
, 'city = NULL' 'city IN (NULL)' , city.
- NULL . , SQL IS, NULL, NULL.
NULL ( ) city:
SELECT *
FROM Customers
WHERE city IS NULL;
, NULL .