DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Median
|
|
|
Count
|
|
|
Distinct
|
|
|
Sum
|
Detailed explanation-1: -Which of the following is not a built in aggregate function in SQL? Explanation: SQL does not include total as a built in aggregate function. The avg is used to find average, max is used to find the maximum and the count is used to count the number of values.
Detailed explanation-2: -SQL Aggregate Functions-AVG, COUNT, DISTINCT, MAX, MIN, SUM.
Detailed explanation-3: -One of the member asked me if I can use DISTINCT in Aggregate Function and does it make any difference. Of course! It does make difference. DISTINCT can be used to return unique rows from a result set and it can be used to force unique column values within an aggregate function.
Detailed explanation-4: -Aggregate functions are not allowed because the WHERE clause is used for filtering data before aggregation.