Chapter 2. Single-Table Queries

In this chapter:

Elements of the SELECT Statement

Predicates and Operators

CASE Expressions

NULLs

All-At-Once Operations

Working with Character Data

Working with Date and Time Data

Querying Metadata

Conclusion

Exercises

Solutions

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 ...

Get Microsoft® SQL Server® 2008 T-SQL Fundamentals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial