Group operations are quite common in the day-to-day life of a SQL programmer. When you use SQL to access a database, it is quite common to expect questions such as:
What is the maximum salary in this department?
How many managers are there in each department?
What is the number of customers for each product?
Can you print the monthly aggregate sales for each region?
You need group operations to answer these questions. Oracle provides a rich set of features to handle group operations. These features include aggregate functions, the GROUP BY clause, the HAVING clause, and the extensions to the GROUP BY clause?ROLLUP, CUBE, and GROUPING SETS.