Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

SELECT

The SELECT statement specifies the columns of data you want to retrieve, where the columns are stored, what criteria the returned data must meet, and the sort order to be applied to the data. A SELECT statement can further group rows of data and assign retrieval criteria at the group level. The components of the SELECT statement are described in Table 21.2.

Table 21.2. Components of a SQL SELECT Statement

Component	Description
SELECT	Specifies the columns of data to be retrieved
FROM	Specifies the table/s from which to retrieve rows
WHERE	Specifies criteria for which returned data must meet
GROUP BY	For aggregate queries, specifies the returned column/s by which the data is to be grouped
HAVING	For aggregate queries, specifies criteria for which the ...