Aggregating Data Using Group Functions

As part of learning Oracle SQL tutorial,Here is good detail on group by oracle 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 in Oracle include: AVG([Distinct/all]  n) Numeric […]