Chapter 2. Single-Table Queries
In this chapter:
This chapter introduces you to the fundamentals of the SELECT statement, focusing for now on queries against a single table. The chapter starts by describing logical query processing—namely, the series of logical phases involved in producing the correct result set of a given SELECT query. The chapter then covers other aspects of single-table queries, including operators, NULLs, manipulation of character and temporal data, ranking, CASE expressions, and querying metadata. Many ...