Chapter 3, Problem 3.25RQ

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.

IS NULL operator:

“IS NULL” operator is used to get values from the column(s) in which the condition is equal to “NULL”.

Syntax:

SELECT * FROM table_Name WHERE column_Name IS NULL;