Warning: Undefined array key -1 in /home/clients/0de9ff9beee4541cf1f61437ce7bce2b/web/hec/inc/html.php on line 1458
Différences
Ci-dessous, les différences entre deux révisions de la page.
| Les deux révisions précédentes Révision précédente | |||
|
3:bases_de_donnees:tp3 [d-m-Y H:i] 83.76.103.242 |
3:bases_de_donnees:tp3 [d-m-Y H:i] 83.76.103.242 |
||
|---|---|---|---|
| Ligne 1: | Ligne 1: | ||
| - | ====== TP3 ====== | ||
| - | 1: | ||
| - | <code sql> | ||
| - | SELECT DateNaissance, | ||
| - | FROM employe | ||
| - | WHERE Nom=' | ||
| - | </ | ||
| - | |||
| - | 2: | ||
| - | <code sql> | ||
| - | SELECT Nom, Adresse | ||
| - | FROM Employe NATURAL JOIN Departement | ||
| - | WHERE NomD = ' | ||
| - | </ | ||
| - | |||
| - | 3: | ||
| - | <code sql> | ||
| - | SELECT E1.Nom, E1.Prenom | ||
| - | FROM Employe E1, Employe E2 | ||
| - | WHERE E1.superieur = E2.noavs AND E2.nom = ' | ||
| - | </ | ||
| - | |||
| - | |||
| - | 4: | ||
| - | <code sql> | ||
| - | Select Nomp FROM Projet P NATURAL JOIN Travaille T JOIN Employe E USING (noavs) | ||
| - | WHERE (E.nom = ' | ||
| - | </ | ||
| - | |||
| - | |||
| - | 5: | ||
| - | <code sql> | ||
| - | SELECT p.nomp FROM Projet p, Travaille t, Employe e, Travaille t2, Employe e2 | ||
| - | WHERE e.nom = ' | ||
| - | AND p.nopro = t.nopro AND t.noavs = e.noavs | ||
| - | AND e2.nom = ' | ||
| - | AND p.nopro = t2.nopro AND t2.noavs = e2.noavs | ||
| - | </ | ||
| - | |||
| - | |||
| - | 6: | ||
| - | <code sql> | ||
| - | SELECT Nom, Prenom FROM Employe e LEFT OUTER JOIN Travaille t ON e.noavs = t.noavs WHERE t.nopro IS NULL | ||
| - | </ | ||
| - | |||
| - | |||
| - | 7: | ||
| - | <code sql> | ||
| - | SELECT | ||
| - | JOIN Employe e ON t.noavs = e.noavs JOIN Departement d ON e.nodep = d.nodep | ||
| - | GROUP BY NomP HAVING COUNT(DISTINCT nodep)=(SELECT COUNT(*)FROM Departement) | ||
| - | </ | ||
