ÐÓÊÎÂÎÄÑÒÂÎ ÏÎ ÐÅËßÖÈÎÍÍÎÉ ÑÓÁÄ DB2

         

ÑÏÐÅÄÈÊÀÒÛ


ïðåäèêàò

: : =         óñëîâèå

|óñëîâèå 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 (âûðàæåíèå—ñåëåêöèè)



Ñîäåðæàíèå ðàçäåëà