Chapter 12.7, Problem 12.29CP

Explanation of Solution

Format of select query output in SQL:

• • The “SELECT” command is used to retrieve data in a database.
• • General syntax for select statement is as follows:

  SELECT *FROM TABLE_NAME

• • Syntax for selecting values from the table is as follows:

SELECT COLUMN_NAME1, COLUMN_NAME2 FROM TABLE_NAME;

• • Order by query is used for specifying the required order to display and it include two different orders or formats namely, ascending order and descending order...