Exercice

Quelle valeur renvoie la dernière instruction SQL de la liste ci-dessous :

num. | Ligne | texte | copie |
CTRL+C pour copier, CTRL+V pour coller
1
CREATE TABLE t (
2
 a integer,
3
 b integer,
4
 c integer);
5
6
 INSERT INTO t 
7
 VALUES (0, 0, 0);
8
9
 INSERT INTO t 
10
 VALUES (1, 0, 0);
11
12
 INSERT INTO t 
13
 SELECT * FROM t;
14
15
 SELECT sum(a) + count(b)
16
 FROM t;
CREATE TABLE t (
 a integer,
 b integer,
 c integer);

 INSERT INTO t 
 VALUES (0, 0, 0);

 INSERT INTO t 
 VALUES (1, 0, 0);

 INSERT INTO t 
 SELECT * FROM t;

 SELECT sum(a) + count(b)
 FROM t;
CorrectionRecommencer