Chapter 4, Problem 16SCG

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 STUDENT_ID FROM STUDENT;

• The given query is used to display each student ID from “STUDENT” table.

“LIKE” clause:

• In “LIKE” clause, user use a wildcard in a condition.
• There are two symbols are used to represents the wildcard.
  • Percent sign (%):
    • This symbol represents any collection of characters.
  • Underscore (_):
    • This symbol represents any individual character.