Chapter 1, Problem 11CAT

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;

GROUP BY Clause:

The GROUP BY clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column

Syntax:

SELECT expression1, expression2, expression_n, aggregate_function (expression) FROM table_name WHERE conditions GROUP BY expression1, expression2, expression_n;

HAVING clause:

“HAVING” clause is used to limit groups “HAVING” clause,  used to overcome “WHERE” clause because, “HAVING” clause uses aggregate functions.

Syntax:

SELECT column_Name1, column_Name2 FROM table_name WHERE [conditions] GROUP BY column_name(s) HAVING [conditions] ORDER BY column_name;