Trusted by millions of Kenyans
LoginRegister
Study resources on Kenyaplex

Get ready-made curriculum aligned revision materials

Exam papers, notes, holiday assignments and topical questions – all aligned to the Kenyan curriculum.

Browse exam papers
Or go directly to:
Class notes Holiday assignments Topical questions Other resources

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

Answer Attachments

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

Exams With Marking Schemes

Related Questions