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