Какая из приведенных ниже таблиц является результатом рекурсивного запроса?
WITH RECURSIVE PX (Major, Minor, Qty) AS ((SELECT Major, Minor, Qty FROM PARTS WHERE PARTS.Major = ‘P1’) UNION ALL (SELECT PX.Major, PARTS.Minor, PX.Qty * PARTS.Qty FROM PX, PARTS where pp.Major = px.Minor))SELECT Major, Minor, Qty FROM PX;
(Отметьте один правильный вариант ответа.)
Варианты ответа
Major | Minor | Qty |
---|---|---|
P1 | P2 | 2 |
P1 | P3 | 3 |
P1 | P4 | 2 |
P1 | P5 | 80 |
P1 | P6 | 42 |
Major | Minor | Qty |
---|---|---|
P1 | P2 | 2 |
P1 | P3 | 3 |
P1 | P4 | 2 |
P1 | P5 | 4 |
P1 | P5 | 24 |
P1 | P6 | 12 |
P1 | P5 | 12 |
P1 | P6 | 6 |
P1 | P6 | 4 |
P1 | P5 | 40 |
P1 | P6 | 20 |
Major | Minor | Qty |
---|---|---|
P1 | P2 | 2 |
P1 | P3 | 3 |
P1 | P4 | 2 |
P1 | P3 | 6 |
P1 | P5 | 4 |
P1 | P5 | 24 |
P1 | P6 | 12 |
P1 | P5 | 12 |
P1 | P6 | 6 |
P1 | P3 | 10 |
P1 | P6 | 4 |
P1 | P5 | 40 |
P1 | P6 | 20 |