Exercice : Tableau final
Que renvoie la dernière instruction SQL de la séquence ci-dessous ?
CTRL+C pour copier, CTRL+V pour coller
1
CREATE TABLE R (a INTEGER, b INTEGER);
2
INSERT INTO R VALUES (1,1);
3
INSERT INTO R VALUES (1,2);
4
INSERT INTO R VALUES (3,3);
5
SELECT * FROM R R1, R R2 WHERE R1.a=R2.a;
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;