Chapter 3, Problem 3.20RQ

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.

DISTINCT Keyword:

“DISTINCT” keyword is used to avoid redundant data (removing duplicate values) from a column.

The syntax for “DISTINCT” keyword is as follows:

SELECT DISTINCT column_Name FROM table_Name;