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