Mark Pearl
  • FROM generates the data set
  • WHERE filters the generated data set
  • GROUP BY aggregates the filtered data set
  • HAVING filters the aggregated data set
  • SELECT transforms the filters aggregated data set
  • ORDER BY sorts the transformed data set
  • LIMIT .. OFFSET frames the sorted data set


Do you really understand SQL’s GROUP BY and HAVING clauses

blog comments powered by Disqus

Want to get my personal insights on what I learn as I learn it? Subscribe now!