SQL group by 的问题

[呵呵112123]

表：login
字段，ID自增 ， time 时间， Islogin bool, UserID 用户ID。
1 2010-04-01 1 223
2 2010-05-02 1 223
3 2010-05-03 0 223
4 2010-05-04 1 223
5 2010-05-05 0 223
6 2010-06-01 0 223
7 2010-06-02 1 223
8 2010-06-03 1 223

查询 223这个ID 一个月登陆了几次
该怎么写？SQL2005

[GOODlivelife]

select convert(varchar(7),[time],120) as 月份,count(1) as 登录次数
from login
where userid=223 and islogin=1
group by convert(varchar(7),[time],120)

[GOODlivelife]

if object_id('[login]') is not null drop table [login]
go
create table [login]([ID] int,[time] datetime,[Islogin] int,[UserID] int)
insert [login]
select 1,'2010-04-01',1,223 union all
select 2,'2010-05-02',1,223 union all
select 3,'2010-05-03',0,223 union all
select 4,'2010-05-04',1,223 union all
select 5,'2010-05-05',0,223 union all
select 6,'2010-06-01',0,223 union all
select 7,'2010-06-02',1,223 union all
select 8,'2010-06-03',1,223
go

select convert(varchar(7),[time],120) as 月份,count(1) as 登录次数
from login
where userid=223 and islogin=1
group by convert(varchar(7),[time],120)
/**
月份      登录次数
------- -----------
2010-04 1
2010-05 2
2010-06 2

(3 行受影响)
**/

[htl258_Tony]

[Quote=引用 1 楼 goodlivelife 的回复:]
SQL code
select convert(varchar(7),[time],120) as 月份,count(1) as 登录次数
from login
where userid=223 and islogin=1
group by convert(varchar(7),[time],120)
[/Quote]正解

[呵呵112123]

网上找了个错的 半天没弄出来

[呵呵112123]

如果是查天的的话是不是 group by convert(varchar(10),[time],120)？？