Crear actividad
Crear actividad
Todas las actividades
Jugar Ordenar Letras
1. all the conditions must be TRUE for a record to be displayed
D A N
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
O M R 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
T C E S E L
10. displays records with the same value in the summary rows
Y G U O R P B
11. limits or filters responses based on the value of aggregate functions
V G N A 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
D O R B Y R E
14. sorts data in ascending order (default)
S C A
15. sorts data in descending order
E S C D
16. used to filter out duplicate rows of data
I N T D C T S I
17. tells us how many of a selected field there are
U N T C O
18. computes the average of a selected numerical field
R E A E G V A
19. allows comparisons with portions of the text of the result
I L E K
20. converts text to capital letters
E R U P P
21. converts text to non-capital letters
R W E O L
22. allows us to add a "mask" to our output for better presentation
H R T O _ C A
23. allows us to rename our output columns
I A L S A