Chapter 5. Retrieving Records Using SQL: The FROM, GROUP BY, and HAVING Clauses
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.
Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
