Can we use aggregate function in WHERE clause?

Question

An aggregate function can be used in a WHERE clause only if that clause is part of a subquery of a HAVING clause and the column name specified in the expression is a correlated reference to a group. If the expression includes more than one column name, each column name must be a correlated reference to the same group.

Why we Cannot use aggregate function in WHERE clause?

We cannot use the WHERE clause with aggregate functions because it works for filtering individual rows. In contrast, HAVING can works with aggregate functions because it is used to filter groups.

Can we use aggregate function in WHERE clause in Oracle?

Aggregate functions cannot be used in a WHERE clause. Its violation will produce the Oracle ORA-00934 group function is not allowed here error message.

Can we use aggregate functions in any clause of a SELECT statement?

You can use aggregate functions in any clause of a SELECT statement. B. You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.

Which clause can be used with aggregate functions?

Which clause is used with an “aggregate functions”? Explanation: “GROUP BY” is used with aggregate functions.

Expert · Answer