Computer Science
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
SQL Joins & Grouping
2 Likes
Answer
To filter out the row and column values before creating groups
Reason — The WHERE clause is used to filter rows and columns values before any grouping occurs in a query with a GROUP BY clause.
Answered By
3 Likes
Related Questions
The sum(), if used in a condition, is used with …………… clause.
- Group by
- With
- Where
- Having
Which clause cannot be used with "aggregate functions" ?
- GROUP BY
- SELECT
- WHERE
- Both (1) and (3)
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
The following SQL is which type of join :
SELECT CUSTOMER.CUST_ID, ORDER.CUST_ID, NAME, ORDER_ID FROM CUSTOMER, ORDER- Equi-join
- Natural join
- Outer join
- Cartesian product