Skip to content
Share
Explore
SQL Basics
Voir et sélectionner des champs
Action
Code SQL
Limiter à 1 champ
SELECT last_name FROM Employees;
Plusieurs champs (virgule)
Changer l’ordre d’affichage
SELECT first_name, last_name, id FROM Employees;
Renommer un champ en sortie : alias
SELECT first_name, last_name AS 'Last Name', id FROM Employees;
There are no rows in this table
Filtrer
Action
Code SQL
Filtrer sur un champ “Texte”
Parfois sensible à la casse
Parfois Quote ou Double Quote
SELECT * FROM Employees WHERE department='Marketing'
Sélection de champs : le champ de la clause WHERE n’est pas dans la clause SELECT
SELECT first_name, last_name FROM Employees WHERE department LIKE 'Marketing'
Insensible à la casse
SELECT first_name, last_name FROM Employees WHERE department LIKE 'Marketing'
Tous les employés dont le nom commence par s ou S.
Pour le paramètre “Contient”, utiliser %.
%s : se termine par, %s% : contient.
SELECT first_name, last_name FROM Employees WHERE department LIKE 's%'
Filtre sur champ Numérique
SELECT * FROM Employees WHERE id=10
There are no rows in this table
Filtres combinés
Clause OR
SELECT * FROM Employees WHERE department='Marketing' OR department='Sales'
Clause AND
SELECT * FROM Employees WHERE department='Marketing' AND tshirt_size = 'L'
Clause IS NOT
SELECT * FROM Employees WHERE department IS NOT 'Marketing'
Si pas de parenthèses, interprétation de gauche à droite
Pas possible dans Excel.
9 lignes
SELECT * FROM Employees WHERE department='Sales' OR department='Marketing' AND tshirt_size='L' AND first_name IS NOT 'Rikki'
There are no rows in this table
Limiter le résultat
There are no rows in this table
Combiner les opérateurs
There are no rows in this table
Fonctions
There are no rows in this table
Valeur unique
There are no rows in this table
Organiser ses données
There are no rows in this table
Données de plusieurs tables
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.