1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as mni
SQL>
SQL> With Data As (
2 Select To_date('01/03/2011','DD/MM/YYYY') As dat, 1 As activation, 'PP' As offre From dual union all
3 Select To_date('01/03/2011','DD/MM/YYYY') As dat, 5, 'PS' From dual union all
4 Select To_date('01/03/2011','DD/MM/YYYY') As dat, 2, 'PS' From dual union all
5 Select To_date('02/03/2011','DD/MM/YYYY') As dat, 4, 'PP' From dual union all
6 Select To_date('02/03/2011','DD/MM/YYYY') As dat, 1, 'PP' From dual
7 )
8 Select dat, Sum(activation),
9 Count(Case When Offre = 'PP' Then 1 End) As PP,
10 Count(Case When Offre = 'PS' Then 1 End) As PS
11 From Data
12 Group By Dat
13 Order By Dat
14 /
DAT SUM(ACTIVATION) PP PS
----------- --------------- ---------- ----------
01/03/2011 8 1 2
02/03/2011 5 2 0
SQL> |
Partager