1 2 3 4 5 6 7 8 9
| select
ct.logon_id,
sum(case when trunc(create_date)=trunc(sysdate) then 1 else 0 end) as trunc(sysdate),
sum(case when trunc(create_date)=trunc(sysdate-1) then 1 else 0 end) as trunc(sysdate-1),
sum(case when trunc(create_date)=trunc(sysdate-2) then 1 else 0 end) as trunc(sysdate-2),
sum(case when trunc(create_date)=trunc(sysdate-3) then 1 else 0 end) as trunc(sysdate-3),
sum(case when trunc(create_date)=trunc(sysdate-4) then 1 else 0 end) as trunc(sysdate-4),
sum(case when trunc(create_date)=trunc(sysdate-5) then 1 else 0 end) as trunc(sysdate-5),
sum(case when trunc(create_date)=trunc(sysdate-6) then 1 else 0 end) as trunc(sysdate-6) |
Partager