SQL Fundamentals, Third Edition

Chapter 2. Getting Information from a Table

This chapter explains the basic technique for getting the information you want from a table when you do not want to make any changes to the data and when all the information is in one table. The table might be very large and you might only want a small amount of data from it.

The Select Statement		33
2-1	The goal: Get a few columns and rows from a table	33
2-2	Overview of the select statement	34
The Select Clause		37
2-3	Overview of the select clause	37
2-4	Use a select clause to get a list of some of the columns	38
2-5	Use a select clause to get a list of all of the columns	41
2-6	Use a select clause to get the distinct values in one column	44
2-7	Use a select clause to get the distinct values in two columns	48
The Where Clause ...