Créer une activité
Créer une activité
Toutes les activités
Jouer Ordonner les Lettres
1. all the conditions must be TRUE for a record to be displayed
N D A
2. limits or filters records retrieved from the database with a condition
H E R E W
3. combines information from multiple tables
N I J O
4. keyword identifying which keys (Primary Key and/or Foreign Key) to be used with JOIN
N O
5. only one of several conditions must be TRUE
R O
6. selects a table in the database
R O M F
7. simplifies query if a field falls within a known set of values
N I
8. means there is nothing in the data field
L L N U
9. Selects fields from the database to print out and perform operations on
C L S T E E
10. displays records with the same value in the summary rows
P B Y O G R U
11. limits or filters responses based on the value of aggregate functions
G N A V I H
12. gives us a running total of all the values of a selected numerical field
M S U
13. defines how we want the query data sorted
B Y R O E D R
14. sorts data in ascending order (default)
C A S
15. sorts data in descending order
C S D E
16. used to filter out duplicate rows of data
T S I C D I T N
17. tells us how many of a selected field there are
O U C T N
18. computes the average of a selected numerical field
E A A E G R V
19. allows comparisons with portions of the text of the result
I E L K
20. converts text to capital letters
E R U P P
21. converts text to non-capital letters
E L R O W
22. allows us to add a "mask" to our output for better presentation
R H T _ A O C
23. allows us to rename our output columns
L A S I A