17,377
社区成员
发帖
与我相关
我的任务
分享
select system,factory,name,count(1)
from 表 where out_date is null
group by
where system,factory,name
group by 后面的 where去掉,粘多了。。
select system,factory,name,count(1)
from 表 where out_date is null
group by system,factory,name
select system,factory,name,count(1)
from 表 where out_date is null
group by
where system,factory,name
这样吗?基础的group by用法啊