Guest User

Untitled

a guest
Dec 11th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. -- #1
  2. SELECT `id_camp`,`localite` FROM `campus`
  3.  
  4. -- #2
  5. SELECT `nom`, campus.nom_camp FROM equipe INNER JOIN campus ON equipe.id_camp=campus.id_camp
  6.  
  7. --#3
  8. SELECT * FROM `equipe` WHERE `fonction`='assistant' AND `equipe_id_camp` IN (130, 140)
  9.  
  10. --#4
  11. SELECT * FROM `equipe` WHERE `date_embauche` BETWEEN '2017-01-01' AND '2017-12-31' AND NOT `fonction`='assistant'
  12.  
  13. --#5
  14. SELECT * FROM `equipe` WHERE `nom` LIKE '%A%' AND `nom` LIKE '%R%'
  15. SELECT * FROM `equipe` WHERE `nom` LIKE '%a%r%'
  16.  
  17. --#6
  18. SELECT * FROM `equipe` WHERE `nom` LIKE '%a%a%'
  19.  
  20. --#7
  21. SELECT * FROM `equipe` WHERE `campus_mgr` IS NULL
  22.  
  23. --#8
  24. SELECT `nom`,`id_eqp`,`fonction`,`date_embauche` FROM `equipe` ORDER BY`date_embauche` DESC
  25.  
  26. --#9
  27. SELECT `nom`,`id_eqp`,`fonction`,`date_embauche` FROM `equipe` ORDER BY `fonction`
  28.  
  29. --#10
  30. SELECT `nom`,`id_eqp`,`fonction`,`date_embauche` FROM `equipe` ORDER BY `id_camp` ASC
Add Comment
Please, Sign In to add comment