Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- connect tpg2/tpg2
- select p_num as "num projet", num_dept as "numero dep" from projet join departement using(num_dept)
- where p_location = 'Tunis';
- select p_num, num_dept from projet join departement using(num_dept)
- where nom_dept = 'P_gestion';
- select nom, adresse from employe join departement using(num_dept)
- where nom_dept = 'P_informatique';
- select nom, prenom
- from employe join departement using (num_dept) join travail_dans using(nss)
- where heure = (
- select heure from travail_dans where (
- nss = (select nss from employe where nom = 'ali' and prenom = 'mohammed'))
- );
- select nom, prenom
- from employe, travail_dans
- where employe.nss= travail_dans.nss and heure = (
- select heure
- from travail_dans ,employe
- where employe.nss= travail_dans.nss and nom = 'ali' and prenom = 'mohamed' and p_num = 1
- )
- and nom != 'ali' and prenom != 'mohamed';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement