4 ms·
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 omi
by theemathas 7y ago
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 7y agoYou don't have to include the orderby field in the result set so I'd say O is before S.