🎴 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.

Change Mode