ÔÓÍÊÖÈß ÂÎ ÔÐÀÇÅ SELECT Ñ ÏÐÅÄÈÊÀÒÎÌ
Âûäàòü êîëè÷åñòâî ïîñòàâîê äëÿ äåòàëè Ð2.
SELECT COUNT (*)
FROM SP
WHERE ÍÎÌÅÐ_ÄÅÒÀËÈ = 'Ð2';
Ðåçóëüòàò:
4
Âûäàòü îáùåå êîëè÷åñòâî ïîñòàâëÿåìûõ äåòàëåé Ð2.
SELECT SUM (ÊÎËÈ×ÅÑÒÂÎ)
FROM SP
WHERE ÍÎÌÅÐ_ÄÅÒÀËÈ = 'Ð2';
Ðåçóëüòàò:
1000