Michal Koláček

Projects Garden Datavis Teach Imho Uses Nmk GitHub LinkedIn Email

Understand that SQL queries start with FROM

  • data-coding
  • idea
  • sql
  • winter

When executing, the order actually is:

FROM
JOIN
ON
WHERE
GROUP BY
HAVING
SELECT -- including window functions
ORDER BY
LIMIT

Metadata

created: 2019-10-09

updated: 2025-01-08

sources: https://jvns.ca/blog/2019/10/03/sql-queries-don-t-start-with-select/

Links to this note

Learn SQL

Learning SQL Climber SQL Zoo DataCamp Summer of SQL Lost at SQL Window Functions – i...


Related Notes

Be able to explain what you do to your granny

Because it is actually quite hard. And even though it's also difficult to define it in technical ...

Become an analytics storyteller

Consider a role of an Analytics Engineer

The full context of analytics engineering is to be found in The Analytics Engineering Guide. ...

Consider using notebooks for analyses

Well, notebook programming environments can be really handy for doing certain types of interac...