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 N A D 2 limits or filters records retrieved from the database with a condition H E E R W 3 combines information from multiple tables O I J N 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 R 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 U N 9 Selects fields from the database to print out and perform operations on E C T L E S 10 displays records with the same value in the summary rows O Y B P G R U 11 limits or filters responses based on the value of aggregate functions G I N A V H 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 R R Y B D E O 14 sorts data in ascending order (default) A C S 15 sorts data in descending order C E D S 16 used to filter out duplicate rows of data I S I T T N D C 17 tells us how many of a selected field there are O C T N U 18 computes the average of a selected numerical field A R V A G E E 19 allows comparisons with portions of the text of the result E I K L 20 converts text to capital letters E U P P R 21 converts text to non-capital letters L E R W O 22 allows us to add a "mask" to our output for better presentation A T _ O R H C 23 allows us to rename our output columns L A I A S
New game