Mark Pearl

10 June 2017

10 Easy Steps to understanding SQL

  • 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

References

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!


/