select userid,trunc(redate,'dd'),count(1) from a where trunc(sysdate,'mm')=trunc(redate,'mm') group by userid,trunc(redate,'dd');
select userid,to_char(redate,'yyyy-mm-dd'),count(1) from A where to_char(redate,'mm')=to_char(sysdate,'mm') group by to_char(redate,'yyyy-mm-dd'),userid
from a
where trunc(sysdate,'mm')=trunc(redate,'mm')
group by userid,trunc(redate,'dd');
select userid,to_char(redate,'yyyy-mm-dd'),count(1)
from A
where to_char(redate,'mm')=to_char(sysdate,'mm')
group by to_char(redate,'yyyy-mm-dd'),userid