Get premium membership and access questions with answers, video lessons as well as revision papers.

Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?

      

Explain how the GROUP BY clause works. What is the difference between the WHERE and HAVING clauses?

  

Answers


kelvin
SQL first applies the WHERE clause. Then it conceptually arranges the table based on the grouping column(s). Next, applies the HAVING clause and finally orders the result according to the ORDER BY clause.
kevowmuchiri answered the question on July 4, 2018 at 15:41


Next: What restrictions apply to the use of the aggregate functions within the SELECT statement? How do nulls affect the aggregate functions?
Previous: What is the difference between a sub query and a join? Under what circumstances would you not be able to use a sub query?

View More Computer Science Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions