Chapter 15, Problem 5SA

Program Plan Intro

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 * FROM Book;

Here, “Book” denotes name of table. The given query retrieves all fields available in table “Book”.