ÂÛÁÎÐÊÀ Ñ ÈÑÏÎËÜÇÎÂÀÍÈÅÌ BETWEEN (ìåæäó)
Âûäàòü ñâåäåíèÿ î äåòàëÿõ, âåñ êîòîðûõ íàõîäèòñÿ â äèàïàçîíå îò 16 äî 19 âêëþ÷èòåëüíî:
SELECT ÍÎÌÅÐ_ÄÅÒÀËÈ, ÍÀÇÂÀÍÈÅ, ÖÂÅÒ, ÂÅÑ, ÃÎÐÎÄ
FROM P
WHERE ÂÅÑ BETWEEN 16 AND 19;
Èìååì ñëåäóþùèé ðåçóëüòàò:
|
|
ÍÎÌÅÐ_ÄÅÒÀËÈ
|
ÍÀÇÂÀÍÈÅ
|
ÖÂÅÒ
|
ÂÅÑ
|
ÃÎÐÎÄ
|
|
Ð2
ÐÇ
Ð6
|
Áîëò
Âèíò
Áëþì
|
Çåëåíûé
Ãîëóáîé
Êðàñíûé
|
17
17
19
|
Ïàðèæ
Ðèì
Ëîíäîí
Ìîæåò áûòü òàêæå ñïåöèôèöèðîâàíî NOT BETWEEN (íå ïðèíàäëåæèò äèàïàçîíó ìåæäó), íàïðèìåð:
SELECT ÍÎÌÅÐ_ÄÅÒÀËÈ, ÍÀÇÂÀÍÈÅ. ÖÂÅÒ, ÂÅÑ, ÃÎÐÎÄ
FROM P
WHERE ÂÅÑ NOT BETWEEN 16 AND 19;
Ïîëó÷àåì òîãäà:
|
|
ÍÎÌÅÐ_ÄÅÒÀËÈ
|
ÍÀÇÂÀÍÈÅ
|
ÖÂÅÒ
|
ÂÅÑ
|
ÃÎÐÎÄ
|
|
Ð1
Ð4
Ð5
|
Ãàéêà
Âèíò
Êóëà÷îê
|
Êðàñíûé
Êðàñíûé
Ãîëóáîé
|
12
14
12
|
Ëîíäîí
Ëîíäîí
Ïàðèæ
Ñîäåðæàíèå ðàçäåëà
