Chapter 5, Problem 6TD

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.

“NOT IN” Operator: In SQL, “NOT IN” operator is used to select values from the table which are not equal to any of the values from the mentioned table.

Syntax:

SELECT column_Name(s) FROM table_Name WHERE column_Name NOT IN (value1, value2, ...);