1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| CREATE TABLE TMP (
CodeConnaissance VARCHAR(25),
Nbre_rep VARCHAR(25),
Score_num1 VARCHAR(25),
Score_num2 VARCHAR(25)
);
INSERT INTO TMP
VALUES ('001CON05', '0', '3', '3');
INSERT INTO TMP
VALUES ('002CON04', '0', '2', '3');
INSERT INTO TMP
VALUES ('003CON04', '0', '1', '3');
INSERT INTO TMP
VALUES ('004CON05', '0', '3', '3');
INSERT INTO TMP
VALUES ('005CON04', '0', '1', '3');
INSERT INTO TMP
VALUES ('006CON04', '0', '3', '1');
SELECT Count(*) AS Total
FROM TMP
WHERE Score_num1=1
AND CodeConnaissance LIKE ( '%04'); |
Partager