O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

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

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
ComponentDescription
SELECTSpecifies the columns of data to be retrieved
FROMSpecifies the table/s from which to retrieve rows
WHERESpecifies criteria for which returned data must meet
GROUP BYFor aggregate queries, specifies the returned column/s by which the data is to be grouped
HAVINGFor aggregate queries, specifies criteria for which the ...

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