Chapter 16, Problem 1FTE

Explanation of Solution

Given SQL statement:

SELECT * FROM Coffee WHERE Description = “French Roast Dark”

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.
• The “FROM” denotes a clause to choose from a table.
• The “WHERE” clause specifies that SQL statement should only affect rows with specified criteria.
• The criteria are expressed in form of predicates.
• It is not a mandatory clause, but it is used to limit number of rows affected by SQL statement.
• Specific fields could be selected by giving particular field names in “SELECT” statement...