mysql的 select count(distinct column) 

select  department,count(distinct project_id) as projectNum
from cms_system_project_department
group by  department

posted on 2020-07-28 09:52  小甜瓜安东泥  阅读(404)  评论(0)  编辑  收藏  举报