Which clause is used when the group results of a subquery need to be restricted,based on some condition?
A) GROUP BY
B) HAVING
C) WHERE
D) ORDER BY

Question

​Which clause is used when the group results of a subquery need to be restricted,based on some condition?
A) ​GROUP BY
B) ​HAVING
C) ​WHERE
D) ​ORDER BY

Quizplus · Accepted Answer

The HAVING clause is used to restrict the results of a GROUP BY clause based on some condition. The WHERE clause is used to filter the results of a query before they are grouped or aggregated. The GROUP BY clause is used to group the results of a query by one or more columns. The ORDER BY clause is used to sort the results of a query in ascending or descending order based on one or more columns.

​Which Clause Is Used When the Group Results of a Subquery

Which Clause Is Used When the Group Results of a Subquery