求助，这样的SQL语句的写法

Question

select number=count(*),[date] from t group by [date]

Answer 1

select count(*) as number,date from table group by date

Answer 2

select 
    number = count(user),
    [date]
from
    表
group by 
    [date]
如果需要过滤重复的记录select 
    number = count(distinct user),
    [date]
from
    表
group by 
    [date]

Answer 3

create table UserTable
([user] varchar(20),
[date] smalldatetime)insert into UserTable
select 'sadf' ,'2005-05-01'
union
select 'fsdfs' ,'2005-05-01'
union
select 'aqweq' ,'2005-05-01'
union
select '1231' ,'2005-05-02'
union
select 'asda' ,'2005-05-02'
union 
select 'kjkjk' ,'2005-05-02'select count([user]) as number,convert(nvarchar(10),a.[date],121) from UserTable,
(select distinct [date] as [date] from UserTable) a
where UserTable.[date]<=a.[date]
group by a.[date]

Answer 4

select count([user]) as number,convert(nvarchar(10),a.[date],112) from UserTable,
(select distinct [date] as [date] from UserTable) a
where UserTable.[date]<=a.[date]
group by a.[date]
运行结果:
3 20050501
6 20050502

Answer 5

select number=count([user]),[date] 
from t 
group by [date]
order by [date]