Chapter 5, Problem 5TD

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.

 “EXISTS” operator: In SQL, “EXISTS” operator is used to test whether the record is present in the subquery. This “EXISTS” operator returns “true” if the subquery returns one or more records.

 Syntax:

SELECT column_Name(s) FROM table_Name WHERE EXISTS (SELECT column_Name FROM table_Name WHERE condition);