The SELECT Clause

This is used to retrieve records from a table. It creates a subset of the table called a ResultSet. The syntax is:

SELECT field-list FROM tableName