Sql Excel : The SELECT Statement

This chapter has already included several examples of simple SQL queries. More
formally, the SELECT statement consists of clauses, the most important of which
are:
WITH
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
These clauses are always in this order. There is a close relationship between the
dataflow operations discussed in the previous section and these clauses.
Note that a SELECT statement can contain subqueries within it. Supporting
subqueries provide much of the power of SQL.