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

Âûäàòü íîìåðà ïîñòàâùèêîâ ñî çíà÷åíèåì ïîëÿ ÑÎÑÒÎßÍÈÅ ìåíüøèì, ÷åì òåêóùåå ìàêñèìàëüíîå ñîñòîÿíèå â òàáëèöå S.

SELECT                ÍÎÌÅЗÏÎÑÒÀÂÙÈÊÀ

FROM                   S

WHERE                ÑÎÑÒÎßÍÈÅ <

(SELECT MAX (ÑÎÑÒÎßÍÈÅ)

FROM S);

Ðåçóëüòàò:

       ÍÎÌÅÐ_ ÏÎÑÒÀÂÙÈÊÀ

S1

S2

S4

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

---

---

Ãëàâíàÿ ñàéòà

---