PL/SQL Read combination and average combination vaules
930602Jun 5 2012 — edited Jun 6 2012Hi Guys
I was wondering how to find the average of each combination columns.
e.g
combo1|combo2|combo3|number|type |name
----------------------------------------------------------------------
w |e |d |9 |number |first
w |e |d |5 |number |first
w |e |d |6 |number |first
r |t |s |4 |number |second
r |t |s |6 |number |second
w |e |d |6 |number |first
r |t |s |6 |number |second
the result should be.
combo1|combo2|combo3|number|type
-----------------------------------------------------
w |e |d |6.5 |average
r |t |s |5.333 |average
There may be more combo's in the real database (possibly a large database) is there a way to find average for all combos.
Thanks in advance.