The SELECT statement retrieves data from the database. You can use it to retrieve a subset of the rows in one or more tables and to retrieve a subset of the columns in one or more tables.
This chapter focuses on the basics of single-table SELECT statements. Advanced uses of SELECT are described later in this manual.
Query overview
The SELECT list: specifying columns
The FROM clause: specifying tables
The WHERE clause: specifying rows