SFWGHO - A Way to Remember the Order of Commands in SQL

The Problem - SFWGHO

When composing T-SQL, Microsoft's interpretation of the SQL database dialect, the charges need to arrive in a specific request. This is:

- SELECT (choosing information)

- FROM (expressing which table to get information from)

- WHERE (any separating conditions)

- GROUP BY (determining any conglomeration to perform)

- HAVING (any separating to perform on totaled information)

- ORDER BY (which request to show the last lines in)

It is essential that you put these charges organized appropriately, else you'll get a sentence structure mistake. The acronym for the orders is SFWGHO, so it's extremely only an issue of figuring out how to recall this arrangement of letters.

Arrangements

When he initially met this issue, the writer of this article trawled the Internet for acronyms. I discovered one site which was running an opposition, with one contestant:

Elusive Fish Will Garnish Hungry Orcas

Without a doubt there must be preferable acronyms over that! A little reflection thought of the accompanying thoughts:

Six Fat Wives Gross Husbands Out

Sweat-soaked Feet Will Give Horrible Odors

Out of these, the second appears to be better (it's absolutely in better taste!). So here is our suggestion for how to recall the request of orders in SQL:

Sweat-soaked or SELECT

FEET or FROM

WILL or WHERE

GIVE or GROUP BY

Shocking or HAVING

Smells or ORDER BY

So now there's no reason for getting the request of SQL orders wrong, we simply need to figure out how to make sure to place commas in the perfect place constantly...

Andy Brown runs SQL instructional classes for Wise Owl Business Solutions, and additionally creating Access and SQL Server databases.