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