DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A label in the first row
|
|
|
Similar facts in each column
|
|
|
No blank rows or columns in the selected range
|
|
|
A total in the last row
|
Detailed explanation-1: -Which of the following is NOT a GROUP BY function? Answer: C. NVL is a general function used to provide alternate value to the NULL values. The functions MAX, MIN and AVG can be used as GROUP BY functions.
Detailed explanation-2: -Let’s say you want to get last record in each group, that is, for each product. First we use GROUP BY to get most recent date for each group. Now that we know the most recent date for each group, we join this result with our original table to get latest record by date group.
Detailed explanation-3: -SQL COUNT() function counts the total number of rows present in the database.
Detailed explanation-4: -We can use the command FIRST() to extract the first entry of a particular column and LAST() to extract the last entry of a particular column in a Table.