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