1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
| CREATE VIEW vue_union
AS ( SELECT tb1.id
FROM matable AS tb1
WHERE tb1.valeur < 5
UNION
SELECT tb2.id
FROM autretbl AS tb2
WHERE tb2.valeur > 8
)
;
SELECT vue.id
FROM vue_union AS vue
WHERE vue.id > 10
;
CREATE VIEW vue_groupe
AS ( SELECT tb1.id
, tb2.lib
, SUM(tb1.valeur) AS somme
, MIN(tb1.valeur) AS mini
, MAX(tb1.valeur) AS maxi
, COUNT(*) AS nombre
FROM matable AS tb1
INNER JOIN
meslibs AS tb2
ON tb1.idlib = tb2.idlib
GROUP BY tb1.id, tb2.lib
)
;
SELECT vue.id
, vue.libelle
FROM vue_groupe AS vue
; |
Partager