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.
|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 ...|