π΄ Flashcard Mode
SQL Functions and Joins
Card1 / 20
Mastered0
Review0
QuestionClick to flip
We can nest Group Functions
AnswerClick to flip back
A
False
π‘ Explanation:
In Oracle SQL, you cannot directly nest group functions like AVG(MAX(salary)) at the same level. Group functions return a single value per group, so nesting them directly doesn't make logical sense. However, you can use group functions in subqueries or the HAVING clause where they operate on different grouping levels. The claimed answer 'False' is correct.