Chapter 3, Problem 3.24RQ

Program Plan Intro

Display values from table:

The contents from the table can be viewed by using “SELECT” statement which comes under Data Manipulation Language (DML).

The Syntax to view the contents using asterisk (*) is as follows:

SELECT * FROM table_Name;

Selective columns can also be retrieved by replacing all the column(s) names in place of the asterisk symbol.

WHERE Statement:

“WHERE” statement is used limit the number of rows.

For example: Consider a table “FTable” that has two columns named “FruitName” and “Color”. “WHERE” clause is used when there is a need to display the entire FruitName whose color is Red.

SELECT * FROM FTable WHERE color = 'red';

When the above statement is executed, red colored fruits get displayed.

LIKE operator:

“LIKE” operator is used to get set of values which matches the set of characters. The “LIKE” operator uses “%” sign and it uses underscore (_) which is used to represent the characters.

Syntax:

SELECT * FROM table_Name WHERE column_Name LIKE pattern;