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

ÔÓÍÊÖÈß ÂÎ ÔÐÀÇÅ SELECT Ñ ÏÐÅÄÈÊÀÒÎÌ


Âûäàòü êîëè÷åñòâî ïîñòàâîê äëÿ äåòàëè Ð2.

SELECT                COUNT (*)

FROM                    SP

WHERE                ÍÎÌÅÐ_ÄÅÒÀËÈ = 'Ð2';

Ðåçóëüòàò:

4


Âûäàòü îáùåå êîëè÷åñòâî ïîñòàâëÿåìûõ äåòàëåé Ð2.

SELECT                SUM (ÊÎËÈ×ÅÑÒÂÎ)

FROM                   SP

WHERE                ÍÎÌÅÐ_ÄÅÒÀËÈ = 'Ð2';

Ðåçóëüòàò:

1000



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