Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- #1
- SELECT `id_camp`,`localite` FROM `campus`
- -- #2
- SELECT `nom`, campus.nom_camp FROM equipe INNER JOIN campus ON equipe.id_camp=campus.id_camp
- --#3
- SELECT * FROM `equipe` WHERE `fonction`='assistant' AND `equipe_id_camp` IN (130, 140)
- --#4
- SELECT * FROM `equipe` WHERE `date_embauche` BETWEEN '2017-01-01' AND '2017-12-31' AND NOT `fonction`='assistant'
- --#5
- SELECT * FROM `equipe` WHERE `nom` LIKE '%A%' AND `nom` LIKE '%R%'
- SELECT * FROM `equipe` WHERE `nom` LIKE '%a%r%'
- --#6
- SELECT * FROM `equipe` WHERE `nom` LIKE '%a%a%'
- --#7
- SELECT * FROM `equipe` WHERE `campus_mgr` IS NULL
- --#8
- SELECT `nom`,`id_eqp`,`fonction`,`date_embauche` FROM `equipe` ORDER BY`date_embauche` DESC
- --#9
- SELECT `nom`,`id_eqp`,`fonction`,`date_embauche` FROM `equipe` ORDER BY `fonction`
- --#10
- SELECT `nom`,`id_eqp`,`fonction`,`date_embauche` FROM `equipe` ORDER BY `id_camp` ASC
Add Comment
Please, Sign In to add comment