Chapter 5, Problem 9SCG

Program Plan Intro

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.

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax: QUERY UNION QUERY;