select to_char(do_time, 'YYYY-MM-dd'), count(*) from do , users where users.id=do.user_id and to_char(do_time, 'YYYY-MM-dd')=to_char(registration_time, 'YYYY-MM-dd') and to_char(registration_time, 'YYYY-MM-dd') between '2012-09-20' and '2012-09-22' group by to_char(do_time, 'YYYY-MM-dd')
SELECT TO_CHAR(do_time,'YYYY-MM-dd'),COUNT(*) FROM do, users WHERE users.id=do.user_id AND TO_CHAR(do_time,'YYYY-MM-dd')=to_char(registration_time,'YYYY-MM-dd') AND to_char(registration_time,'YYYY-MM-dd') BEWTEEN '2012-09-20' AND '2012-09-22' GROUP BY to_char(do_time,'YYYY-MM-dd');
按日期分组 select to_char(do_time, 'YYYY-MM-dd'),count(*) from do,users where users.id=do.user_id and to_char(do_time, 'YYYY-MM-dd')=to_char(registration_time, 'YYYY-MM-dd') group by to_char(do_time, 'YYYY-MM-dd')
select uid,count(*),to_char(registration_time, 'YYYY-MM-dd') from do , users where users.id=do.user_id and to_char(registration_time, 'YYYY-MM-dd')=to_char(do_time, 'YYYY-MM-dd') group by uid 按每天每个人操作进行统计(每天指注册日期)
select uid,count(*),to_char(registration_time, 'YYYY-MM-dd') from do , users where users.id=do.user_id and to_char(registration_time, 'YYYY-MM-dd')=to_char(do_time, 'YYYY-MM-dd') group by uid,to_char(registration_time, 'YYYY-MM-dd') 按每天每个人操作进行统计(每天指注册日期)
from do , users
where users.id=do.user_id
and to_char(do_time, 'YYYY-MM-dd')=to_char(registration_time, 'YYYY-MM-dd')
and to_char(registration_time, 'YYYY-MM-dd') between '2012-09-20' and '2012-09-22'
group by to_char(do_time, 'YYYY-MM-dd')
FROM do, users
WHERE users.id=do.user_id
AND TO_CHAR(do_time,'YYYY-MM-dd')=to_char(registration_time,'YYYY-MM-dd')
AND to_char(registration_time,'YYYY-MM-dd') BEWTEEN '2012-09-20' AND '2012-09-22'
GROUP BY to_char(do_time,'YYYY-MM-dd');
select to_char(do_time, 'YYYY-MM-dd'),count(*)
from do,users where
users.id=do.user_id
and to_char(do_time, 'YYYY-MM-dd')=to_char(registration_time, 'YYYY-MM-dd')
group by to_char(do_time, 'YYYY-MM-dd')
from do , users where
users.id=do.user_id
and to_char(registration_time, 'YYYY-MM-dd')=to_char(do_time, 'YYYY-MM-dd')
group by uid
按每天每个人操作进行统计(每天指注册日期)
from do , users where
users.id=do.user_id
and to_char(registration_time, 'YYYY-MM-dd')=to_char(do_time, 'YYYY-MM-dd')
group by uid,to_char(registration_time, 'YYYY-MM-dd')
按每天每个人操作进行统计(每天指注册日期)