Chapter 15.3, Problem 15.12CP

Explanation of Solution

SELECT:

• The “SELECT” statement is been used for selecting data from a database.
• The result table is stored with data and is termed as result set.
• All the fields present in table could be selected using “SELECT” statement.
• Specific fields can be selected by giving particular field names in “SELECT” statement.

Example:

The example for “SELECT” statement is shown below:

SELECT pageNum FROM Book;

Here, “Book” denotes the name of table and “pageNum” denotes number of pages in book. The given query retrieves “pageNum” field in table “Book”...