Aggregate functions are SQL functions designed to allow you to summarize data from multiple rows of a table or view. These aggregate functions, many of which are useful for data warehouse applications, are only valid for use in SQL statements. A simple pl sql tutorial which demonstrate how to use basic aggregate functions like sum, avg, count, max and min.