Ordenar Letras Scrambled SQLVersión en línea Unscramble these SQL keywords por Arthur Van Houten 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 R H E E W 3 combines information from multiple tables N J O I 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 F R 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 N U L 9 Selects fields from the database to print out and perform operations on T L C E E S 10 displays records with the same value in the summary rows B R P G Y U O 11 limits or filters responses based on the value of aggregate functions A V G N H I 12 gives us a running total of all the values of a selected numerical field U M S 13 defines how we want the query data sorted O R D B R E Y 14 sorts data in ascending order (default) S C A 15 sorts data in descending order C S D E 16 used to filter out duplicate rows of data T S C D T I I N 17 tells us how many of a selected field there are U O C T N 18 computes the average of a selected numerical field A A R E V E G 19 allows comparisons with portions of the text of the result I L K E 20 converts text to capital letters U R P P E 21 converts text to non-capital letters R E W L O 22 allows us to add a "mask" to our output for better presentation R T H _ A C O 23 allows us to rename our output columns A L I S A
Crear