In my undergrad class, I was thought that the order is "FWGHOS" (pronounced, "fw...

theemathas on Oct 4, 2019 | parent | context | favorite | on: SQL queries don't start with SELECT

In my undergrad class, I was thought that the order is "FWGHOS" (pronounced, "fwog hose"), i.e., FROM, WHERE, GROUP BY, HAVING, ORDER BY, SELECT. (LIMIT was omitted from this.)

This acronym has "ORDER BY" happen before "SELECT", but this article have them the other way around. Does this difference ever matter?

daxfohl on Oct 4, 2019 [–]

You don't have to include the orderby field in the result set so I'd say O is before S.