Chapter 8, Problem 52P

Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT COLUMN_NAME1, COLUMN_NAME2 FROM TABLE_NAME;

ORDER BY Clause:

SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in both ascending and descending orders. The keyword used to sort values in ascending order is “ASC” and for descending order is “DESC”. By default, it sorts values by ascending order.

Syntax:

SELECT column_Name1, column_Name2 FROM table_Name ORDER BY column_Name2;