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 '时间'
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 '时间'
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 '时间'