Chapter 8. Data Retrieval

After completing this chapter, you will be able to

  • Retrieve data from one or more tables

  • Filter query results

  • Sort query results

T-SQL has hundreds of commands to create and manipulate the database objects needed to manage your business. However, you only have a single command to retrieve data—SELECT. SELECT is the most powerful and flexible command that you will encounter within any programming language. In this chapter, you will begin learning how to take advantage of the basic features of a SELECT statement. You will learn how to retrieve data from one or more tables, filter the results, and apply sorting to the data.


Each chapter within this book has multiple procedures to follow. This chapter, as well as Chapter 9 ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.