Murach is calling SQL Server 2005 for Developers "the SQL book that most developers don't even know they need." Why? There are plenty of SQL Server 2005 features of interest to developers, such as the ability to create database objects using Visual Basic and the option to work with XML data. SQL Server 2005 for Developers covers those two topics, and it offers some hints for juggling various data types, database design and
Chapter 3, How to retrieve data from a single table, introduces the SELECT statement, which is used to get data from one or more tables. The authors discuss how to use SELECT statements to perform seven common operations, from coding column specifications to returning a subset of selected rows. The authors also offer tips for working with the WHERE clause, which acts as a filter for rows in a base table, and the ORDER BY clause, which specifies the sort order for the rows in a result set.
Excerpted from Murach's SQL Server 2005 for Developers (ISBN 978-1-890774-39-4) by Bryan Syverson and Joel Murach.
Copyright © 2007. Published by Mike Murach & Associates Inc.. Reprinted with permission.