Chapter 8, Problem 25P

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:

SELECT * FROM table_Name;

Inner join:

The “inner join” keyword is to select the matching records from two tables. The syntax of “inner join” is as follows:

Syntax:

SELECT column_name FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name;

WHERE clause:

“WHERE” statement is used limit the number of rows. For example: Consider a table “FTable” that has two columns named “FruitName” and “Color”. “WHERE” clause is used when there is a need to display the entire FruitName whose color is Red.

SELECT * FROM FTable WHERE color = 'red';

When the above statement is executed, red colored fruits get displayed.

MAX function:

This function is used to get the maximum value from the column.

Syntax:

SELECT MAX(column_Name) FROM table_Name;

UNION set operator:

The UNION set operator is used to combine the output of two or more than two queries and produce a result. The produced result contains unique values.

Syntax: QUERY UNION QUERY;

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;