Murach's SQL Server 2008 for Developers
How to retrieve data from a single table

This chapter shows you how to use the SQL SELECT statement to retrieve data from a single table. However, the skills covered are the essential ones that apply to any SELECT statement, no matter how many tables it operates on or how complex the retrieval.

Chapter 3 How to retrieve data from a single table
An introduction to the SELECT statement 84
The basic syntax of the SELECT statement 84
SELECT statement examples 86
How to code the SELECT clause 88
How to code column specifications 88
How to name the columns in a result set 90
How to code string expressions 92
How to code arithmetic expressions 94
How to use functions 96
How to use the DISTINCT keyword to eliminate duplicate rows 98
How to use the TOP clause to return a subset of selected rows 100
How to code the WHERE clause 102
How to use comparison operators 102
How to use the AND, OR, and NOT logical operators 104
How to use the IN operator 106
How to use the BETWEEN operator 108
How to use the LIKE operator 110

How to use the IS NULL clause

112
How to code the ORDER BY clause 114
How to sort a result set by a column name 114
How to sort a result set by an alias, an expression, or a column number 116
t


© Copyright 1998- Mike Murach & Associates, Inc.  All rights reserved.

Murach's SQL Server 2008

Learn more about this book

Download this chapter

View the table of contents


More about the eBook



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.