O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required