Que renvoie la dernière instruction SQL de la séquence ci-dessous ?
CREATE TABLE R (a INTEGER, b INTEGER);
INSERT INTO R VALUES (1,1);
INSERT INTO R VALUES (1,2);
INSERT INTO R VALUES (3,3);
SELECT * FROM R R1, R R2 WHERE R1.a=R2.a;
1 | 1 |
1 | 2 |
3 | 3 |
1 | 1 |
1 | 1 |
1 | 2 |
1 | 2 |
3 | 3 |
3 | 3 |
1 | 1 | 1 | 1 |
1 | 1 | 1 | 2 |
1 | 1 | 3 | 3 |
1 | 2 | 1 | 1 |
1 | 2 | 1 | 2 |
1 | 2 | 3 | 3 |
3 | 3 | 1 | 1 |
3 | 3 | 1 | 2 |
3 | 3 | 3 | 3 |
1 | 1 | 1 | 1 |
1 | 1 | 1 | 2 |
1 | 2 | 1 | 1 |
1 | 2 | 1 | 2 |
3 | 3 | 3 | 3 |
1 | 1 | 1 | 2 |
1 | 1 | 3 | 3 |
1 | 2 | 1 | 1 |
1 | 2 | 3 | 3 |
3 | 3 | 1 | 1 |
3 | 3 | 1 | 2 |
1 | 1 |
1 | 2 |
3 | 3 |
1 | 1 |
1 | 1 |
1 | 2 |
1 | 2 |
3 | 3 |
3 | 3 |
1 | 1 | 1 | 1 |
1 | 1 | 1 | 2 |
1 | 1 | 3 | 3 |
1 | 2 | 1 | 1 |
1 | 2 | 1 | 2 |
1 | 2 | 3 | 3 |
3 | 3 | 1 | 1 |
3 | 3 | 1 | 2 |
3 | 3 | 3 | 3 |
1 | 1 | 1 | 1 |
1 | 1 | 1 | 2 |
1 | 2 | 1 | 1 |
1 | 2 | 1 | 2 |
3 | 3 | 3 | 3 |
1 | 1 | 1 | 2 |
1 | 1 | 3 | 3 |
1 | 2 | 1 | 1 |
1 | 2 | 3 | 3 |
3 | 3 | 1 | 1 |
3 | 3 | 1 | 2 |