SELECT Clause Ordering

Search in book...
Toggle Font Controls
Create new playlist

Name your new playlist

Playlist description (optional)
Sign In

Email address

Password

Forgot Password?

or

Continue with Facebook

Continue with Google
Sign Up

Full Name

Email address

Confirm Email Address

Password

or

Continue with Facebook

Continue with Google

`SELECT` Clause Ordering

This is probably a good time to review the order in which SELECT statement clauses are to be specified. Table 10.2 lists all the clauses we have learned thus far, in the order they must be used.

Table 10.2. `SELECT` Clauses and Their Sequence
Clause	Description	Required
`SELECT`	Columns or expressions to be returned	Yes
`FROM`	Table to retrieve data from	Only if selecting from a table
`WHERE`	Row-level filtering	No
`GROUP BY`	Group specification	Only if calculating aggregates by group
`HAVING`	Group-level filtering	No
`ORDER BY`	Output sort order	No

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.

Table of Contents for SELECT Clause Ordering

Create new playlist

Sign In

Sign Up

SELECT Clause Ordering

Table of Contents for
SELECT Clause Ordering

`SELECT` Clause Ordering