Computer Science
Which clause cannot be used with "aggregate functions" ?
- GROUP BY
- SELECT
- WHERE
- Both (1) and (3)
SQL Joins & Grouping
1 Like
Answer
WHERE
Reason — Aggregate functions cannot be used with the WHERE clause in SQL because the WHERE clause filters rows before any grouping or aggregation occurs.
Answered By
1 Like
Related Questions
Function count() is a/an …………… function.
- Single row
- Multiple rows
- Aggregate
- None of these
The sum(), if used in a condition, is used with …………… clause.
- Group by
- With
- Where
- Having
What is the meaning of "WHERE" clause in a GROUP BY query ?
- To filter out the summary groups
- To filter out the column groups
- To filter out the row and column values before creating groups
- None of the mentioned
The following SQL is which type of join :
SELECT CUSTOMER.CUST_ID, ORDER.CUST_ID, NAME, ORDER_ID FROM CUSTOMER, ORDER WHERE CUSTOMER.CUST_ID = ORDER.CUST_ID?- Equi-join
- Natural join
- Outer join
- Cartesian product