Aggregating Data Using Group Functions

As part of learning Oracle SQL tutorial,Here is good detail on Aggregating Data Using Group Functions Group Functions unlike single value functions operate on set of of rows and return one rows per group.  The set of rows may be whole table or the table split into groups Types of Group Functions include: AVG([Distinct/all]  n) Numeric […]