Advertisement
Guest User

Untitled

a guest
Mar 30th, 2017
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. 1)
  2. SELECT emp.nom FROM emp,equipe,projet
  3. WHERE projet.id = 8 AND emp.id = id.emp AND id.projet = projet.id
  4.  
  5. 2)
  6. SELECT COUNT (emp.id)
  7. FROM emp,equipe,projet
  8. WHERE emp.id = id.emp AND id.projet = projet.id
  9. GROUP BY projet.id
  10.  
  11. 3)
  12. SELECT skill.nom FROM skill,projet,skillPro
  13. WHERE projet.id=8 AND projet.id = id.pro AND skill.id = idSkill
  14.  
  15. 4)
  16. SELECT skill.nom FROM skill,eval,emp
  17. WHERE skill.id=id.skill AND emp.id=id.emp AND niveau>=4 AND emp.nom='x'
  18.  
  19. 5)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement