统计

[好帅的一条鱼]

select left(A.monitorby,4),count(A.monitorby) as dd from TM_TODOLIST A join usergroup B on A.ASSIGNTO = B.ID group by A.monitorby;

这个是我想要的结果，统计的那count列是正确的，但是我想加一列名称上去就是表B的name，如果写成下面这样，
select left(A.monitorby,4),count(A.monitorby) as dd,B.name from TM_TODOLIST A join usergroup B on A.ASSIGNTO = B.ID group by A.monitorby,b.name;
结果就不符合了，请问应该怎么写呢？

[叶子]

select left(A.monitorby,4),count(A.monitorby) as dd，max(b.name) as name
from TM_TODOLIST A join usergroup B on A.ASSIGNTO = B.ID group by A.monitorby;

[叶子]

select left(A.monitorby,4),count(A.monitorby) as dd,max(b.name) as name
from TM_TODOLIST A join usergroup B on A.ASSIGNTO = B.ID group by A.monitorby;

标点写成全角的了，修正一下

[AcHerat]

select left(A.monitorby,4),count(A.monitorby) as dd,
    max(b.name) as name  --对name做一个筛选，找其中的一个。
from TM_TODOLIST A join usergroup B 
   on A.ASSIGNTO = B.ID group by A.monitorby
group by left(A.monitorby,4)

[好帅的一条鱼]

太强了，两位，谢谢啦