>
Hi,
Using SQL you can build query like this
select day.day , jan.cnt jan, feb.cnt feb , ..... , dec.cnt dec
from
( select to_char( login_date , 'dd' ) day , count(*) cnt
from login_table
where trunc( login_date , 'mm' ) = to_date( '01.01.'||to_char( login_date,
'yyyy' ) , 'dd.mm.yyyy' )
group by to_char( login_date , 'dd' )
) jan ,
(
select to_char( login_date , 'dd' ) day, count(*) cnt
from login_table
where trunc( login_date , 'mm' ) = to_date( '01.02.'||to_char( login_date,
'yyyy' ) , 'dd.mm.yyyy' )
group by to_char( login_date , 'dd' )
) feb
...
...
...
select to_char( login_date , 'dd' ) day, count(*) cnt
from login_table
where trunc( login_date , 'mm' ) = to_date( '01.12.'||to_char( login_date,
'yyyy' ) , 'dd.mm.yyyy' )
group by to_char( login_date , 'dd' )
) dec
,
( select 1 day from dual
union
select 2 day from dual
union
select 3 day from dual
union
select 4 day from dual
union
select 5 day from dual
union
select 6 day from dual
union
select 7 day from dual
union
select 8 day from dual
union
select 9 day from dual
union
select 10 day from dual
union
select 11 day from dual
union
select 12 day from dual
union
select 13 day from dual
union
select 14 day from dual
union
select 15 day from dual
union
select 16 day from dual
union
select 17 day from dual
union
select 18 day from dual
union
select 19 day from dual
union
select 20 day from dual
union
select 21 day from dual
union
select 22 day from dual
union
select 23 day from dual
union
select 24 day from dual
union
select 25 day from dual
union
select 26 day from dual
union
select 27 day from dual
union
select 28 day from dual
union
select 29 day from dual
union
select 30 day from dual
union
select 31 day from dual
) day
where nov.day(+)=day.day and
dec.day(+)=day.day
Received on Mon Feb 21 2000 - 09:21:02 CST