ÑÏÐÅÄÈÊÀÒÛ
ïðåäèêàò
: : = óñëîâèå
|óñëîâèå AND ïðåäèêàò
|óñëîâèå OR ïðåäèêàò
|NOT ïðåäèêàò
óñëîâèå
: : = óñëîâèå — ñðàâíåíèÿ
| óñëîâèå — between
|óñëîâèå — like
|óñëîâèå — in
|óñëîâèå — exists
óñëîâèå — ñðàâíåíèÿ
: : = ñêàëÿðíîå — âûðàæåíèå îïåðàòîð — ñðàâíåíèÿ ñêàëÿðíîå — âûðàæåíèå
|ñêàëÿðíîå — âûðàæåíèå îïåðàòîð — ñðàâíåíèÿ
(âûðàæåíèå — ñåëåêöèè — äëÿ — ñòîëáöà)
[ñêàëÿðíîå—âûðàæåíèå IS [NOT] NULL
îïåðàòîð – ñðàâíåíèÿ
: : =+| ¬=| < | ¬ < | <= | > | ¬ > | > =
âûðàæåíèå — ñåëåêöèè — äëÿ — ñòîëáöà
: : = ôðàçà — ñåëåêöèè — äëÿ — ñòîëáöà
ôðàçà — from
[ ôðàçà — where]
[ôðàçà — ãðóïïèðîâàíèÿ [ôðàçà — having]]
ôðàçà — ñåëåêöèè — äëÿ — ñòîëáöà
: : = SELECT [DISTINCT] ñêàëÿðíîå — âûðàæåíèå
óñëîâèå — between
: : = èìÿ — ñòîëáöà [NOT] BETWEEN ñêàëÿðíîå — âûðàæåíèå
AND ñêàëÿðíîå — âûðàæåíèå óñëîâèå — like
: : = èìÿ — ñòîëáöà
[NOT] LIKE ñêàëÿðíîå — âûðàæåíèå
óñëîâèå — in
: : = ñêàëÿðíîå âûðàæåíèå [NOT] IN (ìíîæåñòâî — ñêàëÿðîâ)
ìíîæåñòâî — ñêàëÿðîâ
: : = ñïèñîê — êîíñòàíòà
| âûðàæåíèå — ñåëåêöèè — äëÿ — ñòîëáöà
óñëîâèå — exists
: := EXISTS (âûðàæåíèå—ñåëåêöèè)