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

ÈÑÏÎËÜÇÎÂÀÍÈÅ ÔÐÀÇÛ WHERE ñ GROUP BY

Âûäàòü äëÿ êàæäîé ïîñòàâëÿåìîé äåòàëè åå íîìåð è îáùèé îáúåì ïîñòàâîê, çà èñêëþ÷åíèåì ïîñòàâîê ïîñòàâùèêà S1:

SELECT                ÍÎÌÅÐ_ÄÅÒÀËÈ, SUM (ÊÎËÈ×ÅÑÒÂÎ)

 FROM                   SP

WHERE                ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ Ø= 'S1'

GROUP                 BY ÍÎÌÅÐ_ÄÅÒÀËÈ;

Ðåçóëüòàò:

ÍÎÌÅÐ_ÄÅÒÀËÈ

Ð1

300

Ð2

800

Ð4

300

Ð5

400

Ñòðîêè, íå óäîâëåòâîðÿþùèå ôðàçå WHERE, èñêëþ÷àþòñÿ äî òîãî, êàê áóäåò îñóùåñòâëÿòüñÿ êàêîå-ëèáî ãðóïïèðîâàíèå.

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

---