Team Fly 

Page 346

F      Direct               2001-02       3208   365860.13
F      Others                             4542   472249.42
F      Others               2001-01       2486    242615.9
F      Others               2001-02       2056   229633.52
F      Indirect                           2523   327821.09
F      Indirect             2001-01       1053   138395.21
F      Indirect             2001-02       1470   189425.88
M                                        25650  2663902.13
M                           2001-01      13199  1345697.12
M                           2001-02      12451  1318205.01
M      Direct                            13218  1360338.89
M      Direct               2001-01       7038   719146.28
M      Direct               2001-02       6180   641192.61
M      Others                             8061   806395.64
M      Others               2001-01       4310   414603.03
M      Others               2001-02       3751   391792.61
M      Indirect                           4371    497167.6
M      Indirect             2001-01       1851   211947.81
M      Indirect             2001-02       2520   285219.79

In the results, we can see that counts and sums of amount_sold are returned at the following levels:

Image By GENDER, CHANNEL_CLASS, and MONTH

Image Subtotals by MONTH within CHANNEL_CLASS

Image Subtotals by MONTH within GENDER

Image Subtotals by CHANNEL_CLASS within GENDER

Image Subtotals by MONTH

Image Subtotals by CHANNEL_CLASS

Image Subtotals by GENDER

Image Grand total

Analysis Functions

Oracle Database 10g provides a number of ranking and statistical functions that previously would have required some pretty heavy SQL to perform, or an extract to a third-party application. In this section, we will look at the analysis function available and provide examples of their use where appropriate.

Team Fly 
0365