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