Chapter 3, Problem 3.16RQ

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;

Columns can also be retrieved by replacing all the column names in place of the asterisk symbol.

The Syntax to view the contents is as follows:

SELECT ColName1, ColName2, …, ColNameN FROM table_Name;