select convert(char(10),time,120) as '时间',count(*) as '注册人数'
from account
where time between '2007-10-1' and '2007-10-31'
group by convert(char(10),time,120) as '时间'
order by convert(char(10),time,120) as '时间'
select convert(char(10),time,120) as '时间',count(*) as '注册人数'
from account
group by convert(char(10),time,120) as '时间'
order by convert(char(10),time,120) as '时间'