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.