Can we use WHERE for aggregate function in SQL?

Question

You can't use an aggregate directly in a WHERE clause; that's what HAVING clauses are for. You can use a sub-query which contains an aggregate in the WHERE clause. 11 июн. 2011 г.

Can WHERE be used with aggregate functions in SQL?

You cannot use aggregate functions in a WHERE clause or in a JOIN condition. However, a SELECT statement with aggregate functions in its SELECT list often includes a WHERE clause that restricts the rows to which the aggregate is applied.

Can we use aggregate function in WHERE clause in Oracle?

Aggregate functions work on sets of data. A WHERE clause doesn't have access to entire set, but only to the row that it is currently working on.

Which clause can be used with aggregate functions?

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

Which of the following Cannot be used with aggregate functions?

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

Expert · Answer