Chapter 7, Problem 111C

Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT COLUMN_NAME1, COLUMN_NAME2 FROM TABLE_NAME;

“AND” operator:

The operator used to check two or more conditions using single query. The “AND” operator returns “true” when two conditions are satisfied in the query.

“LIKE” operator:

• • In a “WHERE” clause, the “LIKE” operator is used to search for a particular pattern in a column.
• • The “%” represents 0, 1, or many characters and “_” represents a single character.
• • In MS Access, “*” is used instead of “%” and “?” is used instead of “_”.