We can use Group functions in the WHERE clause

  1. True

  2. False


Correct Option: B

AI Explanation

To answer this question, you need to understand the purpose and usage of group functions and the WHERE clause in SQL.

Option A) True - This option is incorrect because group functions, also known as aggregate functions (e.g., SUM, AVG, COUNT), are typically used in the SELECT clause to perform calculations on a set of rows and return a single value. They cannot be used directly in the WHERE clause.

Option B) False - This option is correct because group functions cannot be used in the WHERE clause. The WHERE clause is used to filter rows based on specific conditions, such as column values. Group functions are used to perform calculations on a set of rows, typically in conjunction with the GROUP BY clause.

The correct answer is B. Group functions cannot be used in the WHERE clause.

Find more quizzes: