Aggregating data - Oracle PL SQL Course - Lesson 7 | SQL courses

Duration: 20:04 min

Summary: Tables in a Oracle database usually contains many rows and it is common to work with these rows using aggregation, which is the a calculation that group several rows of a column and return only one value. This video explain how to work the aggregation functions AVG(), COUNT(), MAX(), and MIN() in order to obtain a data summary. Also, the GROUP BY and the HAVING clause of the SELECT statement are presented through examples in the HR database schema provided by Oracle. Finally, the video shows how to combine the GROUP BY, HAVING, and the ORDER BY clauses to great a report that aggregate and group data by two different columns.