August 2002
Intermediate to advanced
528 pages
10h 12m
English
This chapter will discuss the remaining three SELECT statement clauses: FROM, GROUP BY, and HAVING. The FROM clause is used to identify the location of the data within the database. The GROUP BY clause determines how Oracle will group or aggregate common sets of records. Finally, the HAVING clause is used to eliminate grouped records.