Chapter 7, Problem 101P

Program Plan Intro

SELECT statement:

It is used to retrieve information from the table or database. The syntax for the “SELECT” statement is given below:

Syntax:

SELECT * FROM table_Name;

ORDER BY Clause:

SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in ascending as well as descending order. 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;

LEFT JOIN keyword:

“LEFT JOIN” keyword is used to return all the records from the left side table and also return the matched records from the right side table.

Syntax:

SELECT col_Name FROM table_Name1 LEFT JOIN table_Name2 ON table_Name1.col_Name = table_Name2.col_Name;