ADM 1013 examen dissertations et mémoires
826 ADM 1013 examen dissertations gratuites 826 - 826
-
Examen sur les bases de données
PARITE 1 ------------------------------------------------------------------- Q1.1 WITH RECURSIVE hierarchie(num_agence, num_mere, nom_agence) AS ( SELECT num_agence, num_mere, nom_agence FROM agence WHERE nom_agence='Band' UNION ALL SELECT a.num_agence, a.num_mere, a.nom_agence FROM hierarchie h JOIN agence a ON h.num_mere=a.num_agence ) SELECT * FROM hierarchie; Q1.2 WITH RECURSIVE hierarchie(num_agence, num_mere, nom_agence) AS ( SELECT num_agence, num_mere, nom_agence FROM agence WHERE nom_agence='Cakewalk sud' UNION ALL SELECT a.num_agence, a.num_mere, a.nom_agence FROM hierarchie h JOIN agence a ON a.num_mere=h.num_agence ) SELECT * FROM hierarchie; Q1.3
319 Mots / 2 Pages