Langage SQL

1. Projection de données

2. ORDER BY

2.1. Tri

3. WHERE

3.1. Jointure

3.2. AND/ OR

4. FROM

4.1. Tables concernées

5. SELECT

6. GROUP BY

6.1. Regroupement

7. La Projection

7.1. SELECT FROM NOM TABLE

8. La Restriction

8.1. SELECT Nom, Prénom From ELEVES WHERE ELEVES.Ville=”VOIRON

9. La jointure

9.1. SELECT Num FROM CLIENTS, COMMANDE WHERE CLIENTS.codecli = COMMANDE.Codecli AND CLIENTS.Nom = "Baheux" AND CLIENTS.Prenom = "Sosthène

10. Le Regroupement

10.1. SELECT CodeClient, COUNT(*) AS [Nbre Cde en 2018] FROM COMMANDE WHERE Year(Date commande)=2018 GROUP BY CodeClient

11. Le TRI

11.1. SELECT Num FROM CLIENTS, COMMANDE WHERE CLIENTS.codecli = COMMANDE.Codecli AND CLIENTS.Nom LIKE "Baheux" AND CLIENTS.Prenom LIKE "Sosthène" ORDER BY COMMANDE.Date DESC ;