An Overview of the
In Chapter 1, our quick introduction to SQL, we briefly met the main SQL statements that we will encounter as web developers:
In this chapter, we’ll begin our more detailed look into SQL with an overview of the
SELECT statement’s single purpose is to retrieve data from our database and return it to us in a tabular result set. In Chapter 1, we saw some of its syntax:
SELECT expression(s) involving keywords, identifiers, and constants FROM tabular structure(s)
FROM clauses are mandatory; what we didn’t reveal in Chapter 1 is that the
SELECT statement can include optional ...