Single-table SELECT statements
You can query a single table in a database in many ways.
You can tailor a SELECT statement to perform the following actions:
- Retrieve all or specific columns
- Retrieve all or specific rows
- Perform computations or other functions on the retrieved data
- Order the data in various ways
The most basic SELECT statement contains only the two required clauses, the Projection clause and FROM.